MySQL源碼安裝完成后修改安裝路徑啟動問題

在Linux上源碼編譯安裝完mysql后，又將安裝的路徑進(jìn)行了修改，但是發(fā)現(xiàn)在設(shè)置后環(huán)境變量后啟動報錯，如下：

[root@www.linuxidc.com var]# mysqld_safe --user=mysql &

[1] 31248

[root@www.linuxidc.com var]# 110422 11:04:00 mysqld_safe Logging to '/opt/mysql5156/var/HServer_03.err'.
-
 

touch: cannot touch `/opt/mysql5156/var/HServer_03.err': No such file or directory

chown: cannot access `/opt/mysql5156/var/HServer_03.err': No such file or directory

110422 11:04:00 mysqld_safe The file /opt/mysql5156/libexec/mysqld

does not exist or is not executable. Please cd to the mysql installation

directory and restart this script from there as follows:

./bin/mysqld_safe&

See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information

/usr/local/mysql/bin/mysqld_safe: line 100: /opt/mysql5156/var/HServer_03.err: No such file or directory

[1]+ Exit 1 mysqld_safe --user=mysql

按照提示原有的路徑目錄不存在，需要到mysql的相對路徑下啟動～

我的原安裝路徑是在/opt/mysql5156下，具體的安裝過程：

Shell> tar –zxvvf mysql-5.1.56.tar.gz

Shell> cd mysql-5.1.56

Shell> ./configure --prefix=/opt/mysql5156 \

--with-charset=utf8 --with-collation=utf8_general_ci \

--with-extra-charsets=latin1,gb2312 \

--with-plugins=innobase,innodb_plugin,myisam,heap,csv,federated,blackhole \

--enable-local-infile --enable-thread-safe-client

Shell> make

Shell >make install

Shell> cp support-files/my-medium.cnf /etc/my.cnf

Shell>cd /opt/mysql5156

Shell>chown –R mysql .

Shell>chgrp –R mysql .

Shell>bin/mysql_install_db –user=mysql

Shell>chown –R root .

Shell> chown –R mysql var

Shell>vi /root/.bash_profile

PATH=$PATH:$HOME/bin:/opt/mysql5156/bin

現(xiàn)在將/opt/mysql5156/目錄移動到/usr/local/下：

Shell>mv /opt/mysql5156 /usr/local/mysql

Shell>vi /root/.bash_profile

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin

Shell>source /root/.bash_profile

在啟動時出現(xiàn)上述錯誤的主要原因是mysql在編譯安裝時，將路徑/opt/mysql5156寫入了mysql/bin/mysqld_safe腳本中，打開該腳本可以明確看到各個啟動邏輯的判斷都有/opt/mysql5156的影子，那么將所有的/opt/mysql5156 全局替換為/usr/local/mysql，保存后重新啟動，ok了。

另外由于這次的編譯安裝時采用動態(tài)編譯的，還需要修改mysql的動態(tài)函式庫，

Shell>vi /etc/ld.so.conf

/usr/local/mysql/lib/mysql/

Shell>ldconfig

這樣在新的路徑下，編譯安裝的mysql就可以無礙使用了。

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]