mysql 5.1.34

標籤：blog   http   os   io   使用   ar   for   檔案   art   

 在make之前，將MAKEFILE中的do abi check注釋，不要注釋名字。。。mysql 5.1 編譯安裝分類： mysql2012-04-06 13:01 17175人閱讀 評論(0) 收藏 舉報mysqlfile編譯器測試oracleinput

---------1.install mysql

--1.為mysql新群組和使用者

#groupadd mysql

#useradd -g mysql  mysql

--2.檢查是否有編譯器

#su - root

#rpm -qa | grep gcc gcc-c++

--3.解壓
#cd /usr/local/src

# tar xvzf mysql-5.1.47.tar.gz

# cd mysql-5.1.47

--4.配置和編譯

#chmod +x configure

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

#make

#make install

--5.安裝選項檔案，將當前檔案作為模板

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

--6.設定mysql許可權

#cd /usr/local/mysql

#chown -R mysql .

#chgrp -R mysql .

--7.建立mysql允許的表

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

#chown -R mysql var

--8.設定mysql開機自啟動:

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

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

#chkconfig --add mysql

--9.測試並運行mysql

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

#service mysql start

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

 

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

--12.連結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.47-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>

--13.查看連接埠3306

#netstat -atln

mysql 5.1.34