Open HuangHongRui opened 5 years ago
版本: 5.7.25 操作步骤:
$ vi /etc/my.conf #打开配置
$ skip-grant-tables #末尾插入此行
$ service mysql restart #重启动Mysql
$ mysql #启动
> ALTER USER 'root'@'localhost'IDENTIFIED BY 'PASSWORD' #设置密码
如果
步骤5
报错:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
> flush privileges; #Mysql>执行该命令
- 继续跑
步骤5
即可更改成功 :)
显示所有数据库:
> show databases;
使用指定数据库
> use TABLE_NAME;
查看当前使用的数据库
> status
> select database();
> show tables;
查看数据库中所有字段与类型:
> select COLUMN_NAME, DATA_TYPE from information_schema.columns where table_schema='table_name';
查看数据表中所有字段:
> show full columns from TABLE_NAME;
查看表数据
> select * from TABLE_NAME
MySQL -Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
It work for me ..
Article