Linux下安装MySQL

一、安装

#命令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;