MYSQL 常用命令

来源：互联网发布：cnki学位论文数据库编辑：程序博客网时间：2024/04/28 01:11

修改MySQL的root用户的密码以及打开远程连接

[root@localhost mysql]# mysql -u root mysql

mysql> use mysql;

mysql> desc user;

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力

mysql> update user set Password = password('123456') where User='root'; //设置root用户密码

mysql> select Host,User,Password from user where User='root';

mysql> flush privileges; mysql> exit

重新登录

[root@localhost mysql]# mysql -u root -p Enter password:123456

若还不能进行远程连接，关闭防火墙

[root@localhost]# /etc/rc.d/init.d/iptables stop

启动mysqlsystemctl start mariadb.service 或者 systemctl start mysqld.service结束systemctl stop mariadb.service 或者 systemctl stop mysqld.service重启systemctl restart mariadb.service 或者 systemctl restart mysqld.service开机自启systemctl enable mariadb.service 或者 systemctl enable mysqld.service

登录MYSQL

--本地连接  mysql –uroot -p  --远程连接  mysql –uwgb –hXXX.XXX.XXX.XXX –p

0 0