linux服务器上安装mysql

妖狐艹你老母 2021-12-01 16:28 362阅读 0赞

mysql版本：mysql-5.6.44-linux-glibc2.12-x86\_64.tar

linux操作系统和版本信息：

![1728242-20190704151415026-1508446560.png][]

1、检查linux服务器上是否已安全mysql

\[root@localhost ~\]\# rpm -qa|grep -i mysql

未安装则无任何信息返回，若已安装则会返回已安装的版本信息，可通过--nodeps关键字卸载mysql

\[root@localhost local\]\#rpm -e *返回的mysql版本信息* \--nodeps

2、添加分组和用户

![1728242-20190704152820252-1056006990.png][]

\[root@localhost ~\]\# cd /usr/local  
\[root@localhost local\]\# groupadd mysql  
\[root@localhost local\]\# useradd -r -g mysql mysql  
\[root@localhost local\]\# groups mysql

3、将下载的安装包上传到/usr/local目录上，解压安装包

\[root@localhost local\]\# tar zxvf mysql-5.6.44-linux-glibc2.12-x86\_64.tar.gz

解压后重命名解压后的文件夹：

\[root@localhost local\]\# mv mysql-5.6.44-linux-glibc2.12-x86\_64 mysql

![1728242-20190704153453104-660928217.png][]

4、进入mysql目录，对用户和分组进行授权

![1728242-20190704153655825-681196394.png][]

5、进入/mysql/scripts/目录执行mysql\_install\_db脚本

![1728242-20190704154646151-1740313342.png][]

安装报错，可直接在线安装perl和autoconf

\[root@localhost scripts\]\# yum install perl

\[root@localhost scripts\]\# yum -y install autoconf

再次执行\[root@localhost scripts\]\# ./mysql\_install\_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/mysql.pid --tmpdir=/tmp

安装成功

6、完成后将mysql/目录下除了data/目录的所有文件，改回root用户所有，mysql用户只需作为mysql/data/目录下所有文件的所有者

![1728242-20190704155640164-365324237.png][]

\[root@localhost mysql\]\# chown -R root:root ./  
\[root@localhost mysql\]\# chown -R mysql:mysql data

7、设置启动脚本

\[root@localhost mysql\]\# cp support-files/mysql.server /etc/init.d/mysqld

\[root@localhost mysql\]\# chmod 755 /etc/init.d/mysqld

8、复制配置文件并修改配置文件

![1728242-20190704155816471-567716399.png][]

\[root@localhost mysql\]\# cp ./support-files/my-default.cnf /etc/my.cnf

修改配置文件，编辑etc/my.cnf文件，在\[mysqld\]下增加

\[mysqld\]  
datadir = /usr/local/mysql/data  
log-error = /usr/local/mysql/data/error.log  
pid-file = /usr/local/mysql/data/mysql.pid  
user = mysql  
tmpdir = /tmp

9、启动服务

![1728242-20190704163156167-1821234032.png][]

\[root@localhost mysql\]\# service mysqld start

10、修改环境变量，编辑etc/profile文件，在文件的最后增加：

MYSQL\_HOME=/usr/local/mysql

export PATH=$PATH:$MYSQL\_HOME/bin

11、连接数据库，进入bin目录：  ./mysql

![1728242-20190704163629738-2072509438.png][]

12、修改root的用户密码和允许远程连接

mysql> use mysql;

mysql> update user set password=passworD("密码") where user='root';

mysql> flush privileges;

mysql> GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY 'trawe901' WITH GRANT OPTION;

mysql> flush privileges;

mysql>exit;

13、配置字符编码等

在/etc/my.cnf中的\[mysqld\]下方添加：

character\_set\_server = utf8

lower\_case\_table\_names=1

log\_bin\_trust\_function\_creators=true

14、通过客户端工具连接mysql数据库成功

![1728242-20190704164538497-1608788188.png][]

转载于:https://www.cnblogs.com/simple1025/p/11133538.html

[1728242-20190704151415026-1508446560.png]: /images/20211201/d7eba42e03124a12be5b5c39984d896d.png
[1728242-20190704152820252-1056006990.png]: /images/20211201/f0e497e038064402b48d5340be184be0.png
[1728242-20190704153453104-660928217.png]: /images/20211201/e763c45a35764c4e8ad446d26ddf271b.png
[1728242-20190704153655825-681196394.png]: /images/20211201/70aef10cc363451b93a32235c7328806.png
[1728242-20190704154646151-1740313342.png]: /images/20211201/463cd4c7914047baaf1ed4d4f03afef3.png
[1728242-20190704155640164-365324237.png]: /images/20211201/07c2de1fdfb540798d84f7679d7afd30.png
[1728242-20190704155816471-567716399.png]: /images/20211201/37f6874894a04b7795750537fde57933.png
[1728242-20190704163156167-1821234032.png]: /images/20211201/7ceea7b874b748bb91231ee01ecf3d89.png
[1728242-20190704163629738-2072509438.png]: /images/20211201/dbf27d5ec9eb46b395810ba817d63f78.png
[1728242-20190704164538497-1608788188.png]: /images/20211201/e764e356baa6496aa1c5305470668e9b.png