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 #启动mysql
service 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.service
systemctl disable firewalld.service