Unbuntu安装mysql

最新推荐文章于 2024-06-01 19:05:32 发布

小小面包树

最新推荐文章于 2024-06-01 19:05:32 发布

阅读量314

点赞数

分类专栏： mysql 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_42265640/article/details/128615059

版权

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

unbuntu中批量安装依赖可以使用aptitude
sudo apt-get install aptitude
sudo aptitude install 包名

安装mysql

上传安装包

把mysql-5.7.38-linux-glibc2.12-x86_64.tar解压：

[root@jiyu02 ~] tar xvf mysql-5.7.38-linux-glibc2.12-x86_64.tar

然后将mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz解压到到home⽬录下并改名为mysql：

[root@jiyu02 ~] tar zxvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
[root@jiyu02 ~] mv ./mysql-5.7.38-linux-glibc2.12-x86_64 /home/
[root@jiyu02 home] mv ./mysql-5.7.38-linux-glibc2.12-x86_64/ mysql

创建归档，数据，临时⽂件夹

[root@jiyu02 mysql] mkdir /home/mysql/arch /home/mysql/data /home/mysql/tmp
#创建⽤户，赋予权限
[root@jiyu02 mysql]# useradd mysql
[root@jiyu02 mysql]# chown -R mysql.mysql /home/mysql

修改vi /etc/my.cnf

[client]
port=3306
socket=/home/mysql/data/mysql.sock
default-character-set=utf8mb4
[mysqld]
datadir=/home/mysql/data
basedir=/home/mysql
socket=/home/mysql/data/mysql.sock
lower_case_table_names=1
user=mysql
port=3306
character-set-server=utf8
skip-grant-tables
symbolic-links=0
[mysqld_safe]
log-error=/home/mysql/data/hostname.err
pid-file=/home/mysql/data/hostname.pid

初始化mysql

/home/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --basedir=/home/mysql/ --datadir=/home/mysql/data/ --initialize

配置mysql服务

复制 mysql.server⽂件到/etc/init.d/⽬录下，重命名为mysql

[root@节点1 etc] cd /home/mysql
#将服务⽂件拷⻉到init.d下，并重命名为mysql
[root@节点1 mysql] cp support-files/mysql.server /etc/init.d/mysql
#赋予可执⾏权限
[root@节点1 mysql] chmod +x /etc/init.d/mysql
[root@节点1 mysql] sudo

配置环境变量

vim /etc/profile
#添加如下内容
export PATH=$PATH:/home/mysql/bin
#使配置生效
source /etc/profile

启动mysql

service mysql start
service mysql status #查看状态

开机自启设置

安装sysv-rc-conf

apt-get install sysv-rc-conf

如果出现E: Unable to locate package sysv-rc-conf
打开sourceslist：sudovi /etc/apt/sources.list
追加：deb http://archive.ubuntu.com/ubuntu/ trusty main universe restricted multiverse
更新源：sudoapt-get update
如果出现ng signatures couldn’t be verified because the public key is not availabl
e: NO_PUBKEY 40976EAF437D05B5 NO_PUBKEY 3B4FE6ACC0B21F32
添加公钥：sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 3B4FE6ACC0B21F32
更新源：sudoapt-get update

重新安装：sudo apt-getinstall sysv-rc-conf

设置开机启动

sudo update-rc.d -f mysql defaults 1

[root@节点1 mysql]  cat /home/mysql/data/hostname.err |grep password
2022-11-04T01:20:41.432419Z 1 [Note] A temporary password is generated for root@localhost: !ZsF3kLwYtRq #这个就是初始密码
2022-11-04T01:23:29.483930Z 3 [Note] Access denied for user 'root'@'10.72.169.223' (using password: YES)
2022-11-04T01:23:53.427102Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2022-11-04T01:24:03.676266Z 5 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2022-11-04T01:54:16.406950Z 12 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2022-11-04T03:13:17.374117Z 12 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.

mysql -u root -p

如果出现：mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
可在系统中查找5及以上版本文件创建软链接解决

查找文件：find / -name ‘libncurses*’

创建软链接：ln -s /usr/lib/x86_64-linux-gnu/libncurses.so.6 /usr/lib/libncurses.so.5

如果出现mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory 同理

[root@节点1 mysql]  mysql -u root -p
#输入刚刚日志中的密码进入
#设置密码为：自定义密码
[root@节点1 mysql]  set password for 'root'@'localhost'=password('自定义密码'); #注意这里密码不要设置过于简单，避免弱口令
#配置远程可以访问
[root@节点1 mysql]  grant all privileges on *.* to 'root'@'%' identified by '自定义密码' with grant option;  #这里的密码自定义
[root@节点1 mysql]  use mysql
#开启root远程权限
[root@节点1 mysql]  delete from user where host!='%';
#刷新
[root@节点1 mysql]  flush privileges;
#退出
[root@节点1 mysql]  quit