[gophper]配置mysql数据库

centos安装配置mysql数据库。

1. 安装mysql

   yum install -y mysql-server mysql mysql-devel 
   

2. 启动

   service mysqld start
   

3. 设置开机启动

   chkconfig mysqld on
   

4. 修改密码

   mysqladmin -u root password '111111'
   

5. 登陆

   mysql -u root -p
   

6. 创建数据库

   create database gophper;
   

7. mysql登录报错“Access denied for user ‘root’@‘localhost’ (using password: YES”的处理方法

   # /etc/init.d/mysqld stop 
   # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 
   # mysql -u root mysql 
   mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’; 
   mysql> FLUSH PRIVILEGES; 
   mysql> quit 
   # /etc/init.d/mysqld restart 
   # mysql -uroot -p 
   Enter password: <输入新设的密码newpassword> 
   mysql>