linux下安装mysql

当出现这个的时候A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in '/root/.mysql_secret'.

要使用这个语句去查询，后面的大写就是随机密码

[root@localhost sql]# cat /root/.mysql_secret# The random password set for the root user at Thu Sep 13 15:17:19 2018 (local time): X0pAdfeWfuowxykI

然后启动Mysql可以参考https://blog.csdn.net/cookie3397/article/details/79347990

service mysqld start #启动mysqlservice mysqld stop #关闭mysql

启动完成后登陆 mysql -uroot -p输入上面的随机密码

进入后修改密码mysql> SET PASSWORD =PASSWORD("123456")

退出Mysql用quit

创建用户、密码及权限范围 第一个 roo t为用户名 @后为适用的主机，‘%’表示所有电脑都可以访问连接，第二个 root 为密码mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.2' IDENTIFIED BY 'root' WITH GRANT OPTION;

立即生效mysql> flush privileges;

-- 查看用户mysql> SELECT DISTINCT CONCAT('User: [', user, '''@''', host, '];') AS USER_HOST FROM user;

--查看端口mysql> show global variables like 'port';

 

不能远程连接

update user set password=PASSWORD("hello@2016!@#")where user="root";GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'hello@2016!@#' WITH GRANT OPTION;FLUSH PRIVILEGES;

systemctl stop firewalld.servicesystemctl disable firewalld.service

转载于:https://www.cnblogs.com/bh752791/p/9667722.html