mysql安装及root密码初始化
安装mysql
[root@sample ~]# yum -y install mysql-server ← 安装MySQL
[root@sample ~]# yum -y install php-mysql ← 安装php-mysql
配置mysql
[root@sample ~]# /etc/init.d/mysqld stop 停止mysql服务
[root@sample ~]# vim /etc/my.cnf mysql服务的配置文件
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
skip-grant-tables #添加这句话,这时候登入mysql就不需要密码
symbolic-links=0
[root@sample ~]# /etc/init.d/mysqld start 启动mysql服务
[root@sample ~]# mysql 登入mysql
mysql> USE mysql ;
mysql> UPDATE user SET Password = password(‘new-password‘) WHERE User = ’root’ ;
<p style="margin-top:0px; margin-bottom:18px; padding-top:0px; padding-bottom:0px; border:0px; vertical-align:baseline; line-height:18px; color:rgb(51,51,51)