一、安装
#命令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;
