一、设置mysql远程访问
grant all on *.* to root@'%' identified by '密码';
flush privileges;
二、设计mysql开机启动
chkconfig mysqld on
三、查看开机启动项
chkconfig --list
字符集修改
[mysqld]
default-character-set=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
增加普通用户后,不能登录,提示ERROR 1045 (28000): Access denied for user 'kbm'@'localhost' (using password: YES),执行:
mysql> use mysql
mysql> delete from user where user='';
mysql> flush privileges;
意思是删除匿名用户。
grant all on *.* to root@'%' identified by '密码';
flush privileges;
二、设计mysql开机启动
chkconfig mysqld on
三、查看开机启动项
chkconfig --list
字符集修改
[mysqld]
default-character-set=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
增加普通用户后,不能登录,提示ERROR 1045 (28000): Access denied for user 'kbm'@'localhost' (using password: YES),执行:
mysql> use mysql
mysql> delete from user where user='';
mysql> flush privileges;
意思是删除匿名用户。