一、安装并配置MySQL
1.1 执行yum命令安装MySQL
yum -y install mysql mysql-server
1.2 把添加MySQL进开机启动项,并立即启动MySQL
chkconfig --levels 235 mysqld on
/etc/init.d/mysqld start
1.3 设置MySQL root帐号密码
mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQLSERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none): <-- 输入系统root密码
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] <-- ENTER
New password: <-- 你的MySQL root密码
Re-enter new password: <-- 你的MySQL root密码
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] <-- ENTER
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] <-- ENTER
... Success!
By default, MySQL comes with a database named 'test' that anyone can
This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] <-- ENTER
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] <-- ENTER
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
二、安装Apache
2.1 使用yum命令安装Apache
yum -y install httpd
2.2 设置开机启动Apache
chkconfig --levels 235 httpd on
2.3 启动Apache
/etc/init.d/httpd start
/etc/init.d/httpd restart
2.4 现在直接在浏览器键入http://localhost或http://本机IP,应该会看到Apache的测试页面
三、安装配置PHP
3.1 使用yum命令安装PHP
yum -y install php
3.2 重启Apache服务器
/etc/init.d/httpd restart
3.3 安装相关模块使用PHP支持MySQL:为了让PHP支持MySQL,我们可以安装php-mysql软件包;也可使用以下命令搜索可用的php模块
yum search php
选择需要的模块进行安装
yum -y install php-mysql php-common php-mbstring php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc
3.4 重启Apache服务器
/etc/init.d/httpd restart
四、安装配置phpMyAdmin
安装好MySQL,Apache及PHP后,为了可视化的管理MySQL数据库,我们需要安装phpMyAdmin。
4.1 下载最新版本phpMyAdmin,下载地址:http://www.phpmyadmin.net/home_page/downloads.php,选择最新版本,如phpMyAdmin-3.5.2-all-languages.tar.bz2
4.2 解压程序包
tar -xvf phpMyAdmin-3.5.2-all-languages.tar.bz2
4.3 移动目录phpMyAdmin-3.5.2-all-languages到/usr/share/phpMyAdmin文件夹(建议手工操作,复制粘贴至/usr/share/目录下,后重命名文件名为phpMyAdmin,使用下面的命令行可能导致打开http://localhost/phpmyadmin时,提示403错误,暂时不知怎么回事- -!)
mv phpMyAdmin-3.5.2-all-languages /usr/share/phpMyAdmin
4.4 进入phpMyAdmin目录
cd /usr/share/phpMyAdmin
4.5 拷贝样本配置文件到config.inc.php文件
cp config.sample.inc.php config.inc.php
4.6 修改Apache配置
vi /etc/httpd/conf.d/phpmyadmin.conf
4.7 写入如下内容
#
# Web application to manage MySQL
#
#<Directory "/usr/share/phpMyAdmin">
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#</Directory>
Alias /phpmyadmin /usr/share/phpMyAdmin
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /mysqladmin /usr/share/phpMyAdmin
写入并退出
:w
:q
4.8 重启Apache服务器
/etc/init.d/httpd restart
4.9 至此,打开页面http://localhost/phpmyadmin即可轻松管理你的mySQL数据库
0.话题发布后没及时显示,请联系官方QQ群管理;
1.话题支持代码,qq截屏直接粘贴,和QQ群一样;
2.问题描述清,比如服务器版本,程序版本;
3.能上代码,就不用文字;
4.把问题发到话题后再发QQ群;
5.如果感觉回复者解答的不错,可以发红包!
6.多帮助别人也是对自己的锻炼!
7.付费讨论中只有提问者和付费用户才可以查看回复
1.评论积分+1;每天最多10次奖励
2.发布话题积分+1;每天最多5次奖励
3.垃圾评论积分-500;
4.黄色,暴力,违反我国法律评论直接封号