一、安装
#命令1
sudo apt-get update
#命令2
sudo apt-get install mysql-server
二、初始化配置
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 (我的选项)
启动服务
service mysql start
三、修改远程访问 (不是必要)
如果数据库配置文件名为mysql.conf, 需要:
cd /etc/mysql/mysql.conf.d
修改配置文件mysqld.cnf, 注释掉:
bind_address=127.0.0.1 表示只允许本地访问,注释掉该行
如果数据库配置文件名为 my.cnf,执行如下步骤:
1.使用数据库
use mysql;
2.新创建一个用户
该用户可以从任何主机以密码123456远程访问MySQL
create user 'root'@'%' identified by '123456';
如果报错 ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'%' ,说明已经存在该用户对应主机,直接第三步授权
3.给用户最大授权
grant all privileges on *.* to 'root'@'%' identified by '123456';
刷新权限表 (最后不能忘记)
FLUSH PRIVILEGES;