源碼安裝mysql-5.5.53.tar.gz-創(chuàng)新互聯(lián)

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

成都創(chuàng)新互聯(lián)主要為客戶(hù)提供服務(wù)項(xiàng)目涵蓋了網(wǎng)頁(yè)視覺(jué)設(shè)計(jì)、VI標(biāo)志設(shè)計(jì)、全網(wǎng)整合營(yíng)銷(xiāo)推廣、網(wǎng)站程序開(kāi)發(fā)、HTML5響應(yīng)式成都網(wǎng)站建設(shè)、移動(dòng)網(wǎng)站建設(shè)、微商城、網(wǎng)站托管及成都網(wǎng)站維護(hù)、WEB系統(tǒng)開(kāi)發(fā)、域名注冊(cè)、國(guó)內(nèi)外服務(wù)器租用、視頻、平面設(shè)計(jì)、SEO優(yōu)化排名。設(shè)計(jì)、前端、后端三個(gè)建站步驟的完善服務(wù)體系。一人跟蹤測(cè)試的建站服務(wù)標(biāo)準(zhǔn)。已經(jīng)為發(fā)電機(jī)回收行業(yè)客戶(hù)提供了網(wǎng)站推廣服務(wù)。

虛擬機(jī)：VMware

數(shù)據(jù)庫(kù)：mysql-5.5.53.tar.gz

注意事項(xiàng)：源碼安裝包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  #從終端上傳到服務(wù)器

#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 立即生效

啟動(dòng)MySQL

添加服務(wù)，拷貝服務(wù)腳本到init.d目錄，并設(shè)置開(kāi)機(jī)啟動(dòng)

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

#chkconfig mysqld on

#chkconfig mysqld --level 2345 on

#service mysqld start

配置root用戶(hù)

MySQL啟動(dòng)成功后，root默認(rèn)沒(méi)有密碼，我們需要設(shè)置root密碼

#mysql

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

實(shí)戰(zhàn)技術(shù)：

[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


另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性?xún)r(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專(zhuān)為企業(yè)上云打造定制，能夠滿(mǎn)足用戶(hù)豐富、多元化的應(yīng)用場(chǎng)景需求。

新聞名稱(chēng)：源碼安裝mysql-5.5.53.tar.gz-創(chuàng)新互聯(lián)
本文URL：http://muchs.cn/article38/egcpp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供微信公眾號(hào)、云服務(wù)器、定制開(kāi)發(fā)、品牌網(wǎng)站設(shè)計(jì)、響應(yīng)式網(wǎng)站、品牌網(wǎng)站建設(shè)

廣告

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

網(wǎng)站建設(shè)網(wǎng)站維護(hù)公司