mysql5.6.22 备忘录

[ERROR] MySQL: Table '.\mysql\user' is marked as crashed and should be repaired

解决办法：%mysql%\bin>myisamchk -c -r ../data/mysql/user.MYI

 

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

解决办法：当前用户权限不够，用root！

 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决办法：密码错误！

 

 

mysql默认用户表

+------+-----------+----------+
| user | host      | password |
+------+-----------+----------+
| root | 127.0.0.1 |          |//允许本机root用户无密码访问，依赖网卡，ipv4形式
| root | ::1       |          |//允许本机root用户无密码访问，依赖网卡，ipv6形式
|      | localhost |          |//允许本机匿名无密码访问，不依赖网卡
+------+-----------+----------+

mysql> set password = password('123457');

mysql> flush privileges;

 

mysql> update user set password=password('123457') where host='127.0.0.1';

mysql> flush privileges;

 

CREATE USER 'demo'@'localhost' IDENTIFIED BY '123457';

INSERT INTO mysql.user (user,host,password) VALUES('demo','%',password('123457')); 

 可能会报错：

ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

打开my.ini，修改为

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

 

 

%mysql%\data\mysql 目录文件

*.frm是描述了表的结构，*.MYD保存了表的数据记录，*.MYI是表的索引

 

 

windows mysql 配置文件加载顺序
->C:/WINDOWS/my.cnf
->C:/WINDOWS/my.ini
->C:/my.cnf
->C:/my.ini
->$installdir(%MYSQL_HOME%)/my.ini

linux mysql 配置文件加载顺序
->/etc/my.cnf
->/etc/mysql/my.cnf
->SYSCONFDIR/my.cnf
->$MYSQL_HOME/my.cnf
-> --defaults-extra-file->~/my.cnf