[iyunv@localhost ~]# cd /var/www/html/wordpress/
[iyunv@localhost wordpress]# ls wp-config*
wp-config-sample.php
[iyunv@localhost wordpress]# cp wp-config-sample.php wp-config.php
[iyunv@localhost wordpress]# vim wp-config.php
define('DB_NAME', 'wordpress_db'); #这里是指定数据库为wordpress_db,如果没有该库需要手动创建
define('DB_USER', 'wordpress'); #这里是指定连接数据库的用户名是wordpress,如果没有该用户需要手动创建用户并授权
define('DB_PASSWORD', 'redhat'); #指定用户密码为redhat
define('DB_HOST', 'localhost'); #指定连接的主机为localhost
2.创建数据库及用户等:
1
[iyunv@localhost ~]# mysql <word_press.sql #执行创建
1
2
3
4
5
6
7
8
#########word_press.sql文件内容##############
USE mysql; #使用mysql库,为了下面优化
DROP USER ''@'localhost'; #删除多余的用户,属于优化
DROP DATABASE test; #删除test库,属于优化
CREATE DATABASE wordpress_db;
GRANT ALL PRIVILEGES ON wordpress_db.* TO 'wordpress'@'localhost' IDENTIFIED BY 'redhat';
FLUSH PRIVILEGES;
SHOW DATABASE;
[iyunv@localhost phpmyadmin]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using ::1 for ServerName
[ OK ]
[iyunv@localhost phpmyadmin]#
刷新重试:
创建用户并授权让登陆:
1
2
3
4
5
6
[iyunv@localhost ~]# mysql <myadmin.sql
#####myadmin.sql文件内容######
[iyunv@localhost ~]# cat myadmin.sql
GRANT ALL PRIVILEGES ON *.* TO 'meng'@'' IDENTIFIED BY 'redhat';
FLUSH PRIVILEGES;
[iyunv@localhost ~]#
[iyunv@localhost ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using ::1 for ServerName
[ OK ]
[iyunv@localhost ~]#