linux mysql

Linux 安装mysql

[root@aliyun175 mysql]# bin/mysqld --initialize --user=mysql --basedir=/root/mysql --datadir=/root/mysqlData
bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

解决

yum search libaio
yum install libaio

[root@aliyun175 mysql]# bin/mysqld --initialize --user=mysql --basedir=/root/mysql --datadir=/root/mysqlData
2019-11-04T07:00:44.347833Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to '/root/mysqlData/' (OS errno: 13 - Permission denied)

解决：bin/mysqld --initialize

[root@aliyun175 mysql]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Failed to start mysqld.service: Unit not found.

解决：

yum install -y mariadb-server

http://jingyan.baidu.com/article/a378c9609eb652b3282830fd.html
http://www.cnblogs.com/bookwed/p/5896619.html

加入防火墙的白名单
http://blog.csdn.net/linuxlsq/article/details/52348625
http://blog.csdn.net/catoop/article/details/50476099

权限问题
http://www.cnblogs.com/fslnet/p/3143344.html

INSERT INTO user (host,user,password) VALUES ('ip','root',123456);

grant all privileges on user.user to root@ip identified by '123456';

http://c.biancheng.net/cpp/html/1443.html

启动mysql

service mysqld start

查看状态
/etc/rc.d/init.d/mysqld status

http://www.2cto.com/database/201310/251824.html
http://www.d5s.cn/archives/9

mysql 添加某个ip 允许访问
http://blog.csdn.net/hanshileiai/article/details/46375449

mysql设置权限

CREATE USER vpeTest@localhost IDENTIFIED BY '123';
grant select,update on user.* to vpe@localhost identified by  '123';

MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 解决方法

https://www.cnblogs.com/susuyu/archive/2013/05/28/3104249.html

centos 7下yum安装后Apache、php、mysql默认安装路径
https://www.cnblogs.com/sunziying/p/6433003.html
解决不能远程连接Linux服务器上MySQL的问题
https://blog.csdn.net/qq473179304/article/details/56665364
如何修改MySQL监听IP地址
https://blog.csdn.net/liqfyiyi/article/details/51162901
Navicat连接不上Linux服务器上的MySQL。
https://blog.csdn.net/lifupingcn/article/details/53695360
CentOS7安装MySQL
https://www.cnblogs.com/bigbrotherer/p/7241845.html
解决Navicat无法连接到MySQL的问题
https://blog.csdn.net/mtbaby/article/details/56836986