Centos下Mysql数据库安装

1、二进制安装文件下载

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

2、解压到/usr/local/mysql目录下

在mysql目录下新建data目录，用于存放mysql数据 新建mysql用户和分组，同时更新mysql的目录的权限

groupadd mysql useradd mysql -g mysql chown -R mysql . chgrp -R mysql .

文件直接解压到mysql当前目录下

3、初始化数据库

./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data ./mysql_install_db可能过时了，若失败可以使用 ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

4、启动数据库

cd /usr/local/mysql/support-files ./mysql.server start

如果报以下错 Starting MySQL.2019-06-15T06:54:18.643437Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid). 设置/var/log/mariadb/和/var/lib/mysql/目录的权限为mysql

修改/etc/my.cnf文件，在mysqld下讲datadir设置为我们指定的数据目录

[mysqld] #datadir=/var/lib/mysql datadir=/usr/local/mysql/data

5、登录数据库

初始化密码保存在/root/.mysql_secret

mysql -uroot -pxxxxx 如果报错：Access denied for user 'root'@'localhost' (using password: YES) vim /etc/my.cnf 在[mysqld]这个条目下加入 skip-grant-tables 保存后退出

重新登陆设置新密码

./mysql.server restart

输入任何语句都报下边的错，则执行如下修改用户密码的语句

You must reset your password using ALTER USER statement before executing this statement.

alter user user() identified by "adam951413";

如果报不能通过制定socket登录

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

可指定登录方式

mysql -uroot -pzLK*8vUp6iZj -S /var/lib/mysql/mysql.sock

6、Navcat登陆不了，端口未打开

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

若远程连接mysql报1130的错， 1130，ERROR 1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'adam951413' WITH GRANT OPTION; flush privileges;

GRANT ALL PRIVILEGES ON . TO 'tymes'@'%' ;FLUSH PRIVILEGES;

7、mysql命令不存在

安装完数据库后，如果还提示mysql不存在，一般是环境变量没配置好的原因，mysql路径在bin下。

vim /etc/profile export PATH=$PATH:/usr/local/mysql/bin source /etc/profile

8、mysql中文显示乱码

在/etc/my.cnf中mysqld下设置 character_set_server=utf8