debian下安装mysql5.1.34

阅读次数：265 次来源：admin 发布时间：2022-03-18 12:48

#cd /usr/local/src

# tar xvzf mysql-5.1.34.tar.gz

# cd mysql-5.5.1.34

配置和编译

#chmod +x configure

# ./configure --prefix=/usr/local/mysql --enable-local-infile

#make

make时会提示有abi相关的错误，在makefile文件中的最后，将abi相关的部分删除即可

#make install

安装选项文件，将当前文件作为模板

#cp support-files/my-medium.cnf /etc/my.cnf

设置mysql权限

#cd /usr/local/mysql

#chown -R mysql .

#chgrp -R mysql .

新建mysql允许的表

#/usr/local/mysql/bin/mysql_install_db --user=mysql

#chown -R mysql var

设置mysql开机自启动:

# cp /usr/local/src/mysql-5.1.34/support-files/mysql.server /etc/rc.d/init.d/mysql

#chmod +x /etc/rc.d/init.d/mysql

#chkconfig --add mysql

测试并运行mysql

#/usr/local/mysql/bin/mysqld_safe --user=mysql &am

#service mysql start

修改mysql管理员密码

#/usr/local/mysql/bin/mysqladmin -u root password password

使用用户登录mysql

# /usr/local/mysql/bin/mysql -u root -

链接mysql代码

# cd /usr/local/mysql/bin/

#for file in *

gt; do

gt; ln -s /usr/local/mysql/bin/$file /usr/bin/$file

gt; done

测试mysql在任意地点能启动mysql:

#cd

# mysql -u root -

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 5.1.34-log Source distributio

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

查看端口3306

#netstat -atl