mysql-5.0.90.tar.gz
上传到 /home 目录
[下面这4步时间太长,视频就不演示了]
cd /home
tar xzvf mysql-5.0.90.tar.gz
cd /home/mysql-5.0.90
./configure --prefix=/usr/local/mysql5.0.90 --with-charset=utf8 --with-extra-charsets=all --enable-thread-safe-client
make
make install
[这4步已安装完成,视频从下面继续]
cp /usr/local/mysql5.0.90/share/mysql/my-small.cnf /etc/my.cnf 执行后选 Y 覆盖
在[mysqld] 和 [client]段都加入如下指令即可:
vi /etc/my.cnf
default-character-set=utf8
/usr/local/mysql5.0.90/bin/mysql_install_db
/usr/local/mysql5.0.90/bin/mysqld_safe --user=root & 启动mysql命令
/usr/local/mysql5.0.90/bin/mysql -u root -p `进入mysql操作 密码为空直接回车确认
use mysql;
update user set Password=password('123456') where User='root';
create database db_account;
create database db_game;
create database db_gmtool;
create database db_log;
use mysql;
update user set host = '%' where user = 'root';
select host, user from user;
exit `退出mysql操作
reboot 重启下机器
蜀门私服