首页 » MYSQL » mysql5.6二进制包安装

mysql5.6二进制包安装

 
#linux最下化安装,安装mysql时候提示错误
#Installing MySQL system tables.../usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
没关系,我们安装这个库就是了
yum install -y libaio
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/mysql-data</pre>
mysql> SELECT user,host,password FROM mysql.user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | 10-4-5-9 | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | 10-4-5-9 | |
+------+-----------+----------+
6 rows in set (0.00 sec)

mysql> UPDATE mysql.user set password = PASSWORD('gechong') WHERE user = 'root';

mysql> DROP USER ''@localhost;

mysql> FLUSH PRIVILEGES;
  
grant all privileges on *.* to root@'%' identified by 'mysqlpassword';//语序远程连接
flush privileges;


原文链接:mysql5.6二进制包安装,转载请注明来源!

0