Ubuntu如何无坑安装mysql

安装mysql-server

1. 使用apt-get 安装mysql-server

sudo apt-get update
sudo apt-get install mysql-server

2. 配置mysql

• 进入 mysql_secure_installation

sudo mysql_secure_installation

• 我的选择

#1
VALIDATE PASSWORD PLUGIN can be used to test passwords...
Press y|Y for Yes, any other key for No: N (我的选项)
#2
Please set the password for root here...
New password: (输入密码)
Re-enter new password: (重复输入)
#3
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them...
Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (我的选项)
#4
Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network...
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (我的选项)
#5
By default, MySQL comes with a database named 'test' that
anyone can access...
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (我的选项)
#6
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (我的选项)

3. 更新用户权限与认证

• 超级管理员进入mysql

sudo mysql

• 查看用户

SELECT user,authentication_string,plugin,host FROM mysql.user;

• 更改root用户密码

# 将下面的password换成你想设定的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

• 重载权限

FLUSH PRIVILEGES;

• 查看更改结果

SELECT user,authentication_string,plugin,host FROM mysql.user;

• 退出mysql

exit;

4. 更新访问权限

# 将下面的更改掉
grant all privileges on *.* to '用户名'@'IP地址' identified by '密码';
# 权限
FLUSH PRIVILEGES;

5. 更改配置信息，实现ip远程访问

# 进去到配置文件目录
cd /etc/mysql/mysql.conf.d/
# 更改配置信息
vi mysqld.cnf
# 将**bind-address = 127.0.0.1** 注释掉或者改成 0.0.0.0

6. 进入mysql开始使用

mysql -uroot -p 

更多学习地址:http://item.taobao.com/item.htm?id=557746408785

7. all access

mysql --help

vi ~/.my.cnf

[mysqld] 
bind-address=0.0.0.0

update user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

sudo service mysqld restart