1. mysql -u root -p
第一次直接回车跳过密码
2. use mysql;
3.执行授权命令
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
MySQL相关问题
10061 :MySQL服务未启动
10060 :3306端口系统防火墙未开放
启动MySQL服务
/etc/init.d/mysqld start
断电后启动失败问题解决方案
cd /var/lib/mysql/
rm -rf mysql.sock
/etc/init.d/mysqld restart
修改root用户密码
set password for root@localhost = password('123456');
修改root用户密码为123456
设置字符集为UTF-8
set character_set_client = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set character_set_server = utf8;
show variables like '%character%';