三,mysql的安装# tar zxvf mysql-4.0.14.tar.gz –C /setup
# cd /setup/mysql-4.0.14
# groupadd mysql
# useradd mysql -g mysql -M -s /bin/false
#./configure --prefix=/usr/local/mysql/ --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --enable-assembler
#echo $?
# make
# make install
# scripts/mysql_install_db生成mysql用户数据库和表文件# cp support-files/my-medium.cnf /etc/my.cnf \copy配置文件,有large,medium,small三个环境下的,根据机器性能选择,如果负荷比较大,可修改里面的一些变量的内存使用值# cp support-files/mysql.server /etc/init.d/mysqld \copy启动的mysqld文件# chmod 700 /etc/init.d/mysqld
# cd /web
# chmod 750 mysql -R
# chgrp mysql mysql -R
# chown mysql mysql/var -R
# cd /web/mysql/libexec
# cp mysqld mysqld.old
# strip mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start
# netstat -atln看看有没有3306的端口打开,如果mysqld不能启动,看看/web/mysql/var下的出错日志,一般都是目录权限没有设置好的问题# ln -s /web/mysql/bin/mysql /sbin/mysql
# ln -s /web/mysql/bin/mysqladmin /sbin/mysqladmin
# mysqladmin -uroot password "youpassword" #设置root帐户的密码# mysql -uroot -p
#输入你设置的密码mysql>;use mysql;
mysql>;delete from user where password=""; #删除用于本机匿名连接的空密码帐号mysql>;flush privileges;
mysql>;quit错误:看到:[1] 5134
[root@shunzi mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/shunzi.pid
030102 21:00:46 mysqld ended提示启动失败了,这是由于权限的问题,执行下列命令:chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql执行:[root@shunzi mysql]# bin/mysqld_safe --user=root &可以看到类似的内容:[1] 5846
5846 pts/1 S 0:00 /bin/sh bin/mysqld_safe --user=root
5864 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --ba这说明mysql服务已经启动了。mysql服务器安装成功了。如还不行,就再检查mysql文件的权限。总之MYSQL的错误问题都出在权限上。细心点就没事。2。安装PHPMYADMIN
ex:/usr/local/apache/htdocs/(这是我网页存放的位置)
a. # mv phpMyAdmin_2.0.5.tar.gz /usr/local/apache/htdocs/移到文件的根目录b. # tar zxvf phpMyAdmin_2.0.5.tar.gz解压缩phpMyAdmin_2.0.5.tar.gz
c.路径/usr/local/apache/htdocs/phpMyAdmin
d.修改设定档# vi config.inc.php3找到下面的部分$cfgServers[1]['host'] = 'localhost';// MySQL的hostname
$cfgServers[1]['port'] = '';// MySQL的port空白表示预设3306
$cfgServers[1]['adv_auth'] = true;//是否采用进阶功能$cfgServers[1]['stduser'] = 'root';// MySQL的管理者$cfgServers[1]['stdpass'] = '123456';// MySQL管理者的密码//我采用root为管理者,密码为123456你可以采用自己喜欢的4.测试开启浏览器,输入http://的网址/phpMyAdmin/...