debian下安裝mysql 5.1.34

標籤：

 

#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 &

#service mysql start

修改mysql管理員密碼
#/usr/local/mysql/bin/mysqladmin -u root password password

 

 
使用使用者登入mysql
# /usr/local/mysql/bin/mysql -u root -p

連結mysql代碼

# cd /usr/local/mysql/bin/
#for file in *;
> do 
> ln -s /usr/local/mysql/bin/$file /usr/bin/$file;
> done

測試mysql在任意地點能啟動mysql:

#cd

# mysql -u root -p

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 distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
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 -atln

debian下安裝mysql 5.1.34