ubutu中安装mysql

//更新源

sudo apt-get update

//安装mysql服务

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 (选择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 (选择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) : N (选择N，允许root远程连接)

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 (选择N，不删除test数据库)

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 (选择Y，修改权限立即生效)

查看mysql状态

systemctl status mysql.service

配置远程访问

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf #找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

• 1

sudo /etc/init.d/mysql restart #重启mysql

• 2

sudo mysql -uroot -p

找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

输入用户密码        

#切换数据库

mysql>use mysql;

#查询用户表命令：

mysql>select User,authentication_string,Host from user;

#查看状态

select host,user,plugin from user;

#设置权限与密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'; #使用mysql_native_password修改加密规则 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER; #更新一下用户的密码 mysql> UPDATE user SET host = '%' WHERE user = 'root'; #允许远程访问

#刷新cache中配置 刷新权限

mysql>flush privileges; mysql>quit;

如果无法更改密码使用flush privileges;然后再进行更改密码，修改加密规则操作。

mysql停止命令

sudo service mysql stop

mysql启动命令

sudo service mysql start

mysql重启命令

service mysql restart