Ubuntu 安装mysql
1. sudo apt-get install mysql-server
2. apt-get isntall mysql-client
3.修改mysql 默认空的密码
update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';
4.设置允许访问
grant all on user to root@'%' identified by 'user_password';
flush privileges;
5.如果执行授权语句后还是不行 查看下3306端口是否只被127.0.0.0 监听,
~# netstat -an | grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
如果是则修改配置文件
vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉 bind-address = 127.0.0.1,然后sudo service mysql restart 即可用客户端登录mysql。