linux系统下如何安装mysql，远程连接mysql数据库

安装版：参考 https://jingyan.baidu.com/article/a378c9609eb652b3282830fd.html

解压版：参考 https://blog.csdn.net/wangshuminjava/article/details/80873997

注意：安装版有script目录，解压版没有

 

解决远程连接数据库：mysql -uroot -p 进入数据库后

授权：

mysql> grant all privileges on *.* to '%'@'%' identified by '123456' with grant option;

刷新：

mysql> flush privileges;

 

附 可能遇到的问题：

① [ERROR] Failed to execute/usr/local/mysql/bin/mysqld --bootstrap --datadir=...

参考：https://blog.csdn.net/yabingshi_tech/article/details/50431999

②./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file:

参考：https://blog.csdn.net/eagle89/article/details/78411184