chkconfig --list | grep mysqld
chkconfig mysqld on
3>查看初始密码:grep "password" /var/log/mysqld.log
4>登录mysql:mysql -u root -p
5>修改密码:SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
修改的密码过于简单可能会报错:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
执行以下语句:
set global validate_password_policy=0;
set global validate_password_length=4;
再执行修改密码语句
6>开放root账户远程访问
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
7>刷新权限表
FLUSH PRIVILEGES;
8>修改字符集为UTF-8
linux中:vim /etc/my.cnf
在[mysqld]部分添加:
port=3306
character-set-server=utf8
在文件末尾新增[client]段,并在[client]段添加:
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8
在[mysql]部分添加:
no-auto-rehash
default-character-set=utf8
修改好之后重启mysqld服务:
service mysqld restart
(导入sql脚本,先use 数据库,再source /home/sql/test.sql)
9>用软件测试远程连接mysql
推荐教程:《centos教程》
以上就是centos 6.5如何安装mysql?的详细内容,更多文章请关注木庄网络博客!
相关阅读 >>
更多相关阅读请进入《CentOS》频道 >>