操作系統(tǒng)：CentOSrelease 6.8 (Final)

專注于為中小企業(yè)提供網站設計、成都網站制作服務,電腦端+手機端+微信端的三站合一,更高效的管理,為中小企業(yè)桐廬免費做網站提供優(yōu)質的服務。我們立足成都，凝聚了一批互聯網行業(yè)人才，有力地推動了1000+企業(yè)的穩(wěn)健成長，幫助中小企業(yè)通過網站建設實現規(guī)模擴充和轉變。

虛擬機：VMware

數據庫：MySQL-5.5.53.tar.gz

注意事項：源碼安裝包mysql-5.5.32.tar.gz之后的版本安裝方式發(fā)生了變化。

安裝步驟如下：

#rpm -qa|grep mysql

#yum remove mysql*

#yum install cmake ncurses.x86_64 ncurses-devel.x86_64 bison-devel

#groupadd mysql

#useradd -g mysql mysql -s nologin

#mkdir -p application

#cd /application

application# mkdir mysql/data -p

#chmod -R 777 /mysql/data

#chmod -R 777 /mysql/data -p

#chmod -R 777 /mysql/data -f

#chown -R mysql:mysql /mysql

#chown -R mysql:mysql /mysql/data

#mkdir /var/lib/mysql

#chown -R mysql:mysql /var/lib/mysql

#rz  #從終端上傳到服務器

#tar xf mysql-5.5.53.tar.gz

[root@localhost mysql-5.5.53]#

cmake \

-DCMAKE_INSTALL_PREFIX=/application/mysql \

-DMYSQL_DATADIR=/application/mysql/data \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

[root@localhost mysql-5.5.53]#make && make install

[root@localhost support-files]# cp my-small.cnf  /etc/my.cnf

[root@sky9890 scripts]# ./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

WARNING: The host '*****' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Installing MySQL system tables...

181025  7:57:40 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.

181025  7:57:40 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.62) starting as process 18880 ...

OK

Filling help tables...

181025  7:57:41 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.

181025  7:57:41 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.62) starting as process 18887 ...

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/local/mysql/bin/mysqladmin -u root password 'new-password'

/usr/local/mysql/bin/mysqladmin -u root -h ****** password 'new-password'

Alternatively you can run:

/usr/local/mysql/bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/local/mysql/mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

配置mysql的環(huán)境變量:

#vim /etc/profile.d/mysql.sh

#export PATH=/usr/local/mysql/bin:$PATH

#source /etc/profile.d/mysql.sh 立即生效

啟動MySQL

添加服務，拷貝服務腳本到init.d目錄，并設置開機啟動

#cp support-files/mysql.server /etc/init.d/mysqld

#chkconfig mysqld on

#chkconfig mysqld --level 2345 on

#service mysqld start

配置root用戶

MySQL啟動成功后，root默認沒有密碼，我們需要設置root密碼

#mysql

mysql> SET PASSWORD = PASSWORD('*****');

實戰(zhàn)技術：

[root@sky9890 ~]# mysql

-bash: mysql: command not found

[root@sky9890 ~]# ln -s /usr/local/mysql/bin/mysql  /usr/bin

[root@sky9890 ~]# mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root@sky9890 ~]# mysql -V

mysql  Ver 14.14 Distrib 5.5.62, for Linux (x86_64) using  EditLine wrapper

文章標題：源碼安裝mysql-5.5.53.tar.gz
URL鏈接：http://chinadenli.net/article26/jighjg.html

成都網站建設公司_創(chuàng)新互聯，為您提供手機網站建設、定制網站、軟件開發(fā)、外貿建站、網站改版、面包屑導航

廣告

聲明：本網站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯