Linux下MySql安裝

1、mysqllinux 安裝、創(chuàng)立組和用戶創(chuàng)立MySQ組，建立MySQ用戶并參加到mysqi組中，不同版本的Unix中，groupadd和useradd的語(yǔ)法可能會(huì)稍有不同。倉(cāng) U建組：#groupadd mysqi倉(cāng) U建用戶： #useradd -g mysqi mysqiPS:輸入完成后再輸入一次，只要提示已存在，那么說(shuō)明創(chuàng)立成功、安裝mysqiPS:如果安裝時(shí)在可視化界面中，可以直接復(fù)制安裝程序到本機(jī)的/home文件夾下。復(fù)制方法：進(jìn)入 U盤復(fù)制安裝程序，然后點(diǎn)擊桌面上的計(jì)算機(jī)一文件系統(tǒng)一找到home文件夾，翻開(kāi)后粘貼即可。如果沒(méi)有可視化操作界面或者想要嘗試命令復(fù)制，可以進(jìn)展以下步驟：安

2、裝程序放在/home/目錄下：先進(jìn)入U(xiǎn)盤文件夾#cd /media/ disk后面跟U盤的名字#is 查看U盤中的容復(fù)制文件到home中cp/media/ U盤的名字/文件所在文件夾的名字 /文件名全名，帶拓展名/home/home可以改為需要復(fù)制到的文件夾的名字，和前面的語(yǔ)句中間有個(gè)空格，請(qǐng)注意進(jìn)入安裝目錄#cd /home/# sql的版本號(hào)需要注意# cd mysql-5.1.58 sql的版本號(hào)需要注意以下指令需要一同輸入用空格隔開(kāi)，不要按回車#./c on figure -prefix=/data/mysql -with-charset=utf8-with-collati on=ut

3、f8_ge neral_ci -with-extra-charsets=all-localstatedir=/var/lib/mysql-with-comment=Source -with-server-suffix=-enterprise-gpl -with-mysqld-user=mysql -without-debug -with-big-tables -with-pthread -en able-static -e nable-thread-safe-clie nt-with-clie nt-ldflags=-all-static -with-mysqld-ldflags=-all-s

4、tatic-en able-assembler -without -n db-debug-with-un ix-socket-path=/data/mysql/tmp/mysql.sock# make# make in stall編譯的時(shí)間可能會(huì)比較長(zhǎng)，畢竟優(yōu)化的比較厲害。配置成功會(huì)提示：MySQL has a Web site at .mysql./ which carries details on thelatest release, upco ming features, and other in formati on to make your work or play with MyS

5、QL more productive. There you can also find information about mailing lists for MySQL discussion.Remember to check the platform specific part of the reference manual for hints about in stalli ng MySQL on your platform. Also have a look at the files in the Docs directory.Thank you for choos ing MySQ

6、L!四、添加MySQL配置文件與訪問(wèn)權(quán)限# cd /data/mysql# bin /mysql_install_db -user=mysql# chown -R root:mysql ./設(shè)置權(quán)限，注意后面有一個(gè)"."# chown -R mysql /var/lib/mysql / 設(shè)置 mysql 目錄權(quán)限，可省略# chgrp -R mysql ./ 注意后面有一個(gè) "."# cp share/mysql/my-largef /etc/myfd (是否覆蓋輸入 yes)五、運(yùn)行MySQL# /data/mysql/bin/mysqld_safe

7、-user=mysql &如果沒(méi)有問(wèn)題的話，應(yīng)該會(huì)出現(xiàn)類似這樣的提示：1 42264# Starti ng mysqld daem on with databases from /usr/local/mysql/var如果出現(xiàn) mysql ended這樣的語(yǔ)句，表示 Mysql沒(méi)有正常啟動(dòng)，你可以到log中查找問(wèn)題，Log文件的通常在/etc/myf中配置。大多數(shù)問(wèn)題是權(quán)限設(shè)置不正確引起的。六、mysql設(shè)置1、root密碼。先忽略，先進(jìn)展第二步，后面設(shè)置完成后在設(shè)置默認(rèn)安裝密碼為空，為了平安你需要修改密碼#/data/mysql/bi n/m ysqladmin -uroot pas

8、sword yourpassword屢次修改密碼mysql> use mysql;mysql> UP DATE user SET Password=PASSWORD('newpasswdrd) whereUSER= root '；mysql> FLUSH PRIVILEGES;mysql> quit2、遠(yuǎn)程訪問(wèn)設(shè)置先進(jìn)入 MySql: #/data/mysql/bin/mysql默認(rèn)只能localhost 訪問(wèn)，將localhost 改為%mysql> use mysql;mysql> update user set host='%&

9、#39; where user = 'root'mysql> FLUSH PRIVILEGES;mysql> quit按照別人提供的方式 update的時(shí)候，出現(xiàn)錯(cuò)誤。mysql> update user set host='%' where user = 'root'ERROR 1062 (23000): Duplicate en try '%-root' for key 'PRIMARY'然后查看了下數(shù)據(jù)庫(kù)的host信息如下：mysql> select host from user wh

10、ere user = 'root'+| host |+| % | 127.0.0.1 | localhost.localdoma in |+3 rows in set (0.00 sec)host已經(jīng)有了 %這個(gè)值，所以直接運(yùn)行命令：mysql>flush privileges;再用 mysql administrator 連接成功！ ！3、防火墻端口設(shè)置查看3306端口是否翻開(kāi)。要注意在防火墻中開(kāi)放該端口#n etstat -atl n翻開(kāi)防火墻# vi/etc/sysc on fig/iptables在翻開(kāi)文件中參加-A RH-Firewall-1-INPUT -m

11、state -state NEW -m tcp -p tcp -dport 3306 -j ACCEPT重啟防火墻# /etc/rc.d/i nit.d/iptables restart七、設(shè)置開(kāi)機(jī)啟動(dòng)# cp share/mysql/mysql.server /etc/rc.d/init.d/mysql/ 開(kāi)機(jī)自動(dòng)啟動(dòng) mysql。輸入完成后一定要檢查一下，如果錯(cuò)了就要重新裝 # chmod 755 /etc/rc.d/i nit.d/mysql# chkc onfig -add mysql啟動(dòng)mysql下面兩個(gè)命令都行#service mysql start# /etc/i ni t.d/

12、mysql start 這是另一種啟動(dòng)方式 附：遇到問(wèn)題(/usr/local/mysql/b in/mysql -u root -p提示Enter password:輸入密碼，回車進(jìn)入,初始密碼為空)/ 關(guān)閉 MySQL# /etc/i nit.d/mysqld stop具體步驟：登陸到 mysql首先 use mysql ；按照別人提供的方式update的時(shí)候，出現(xiàn)錯(cuò)誤。mysql> update user set host='%' where user = 'root'ERROR 1062 (23000): Duplicate en try '

13、;%-root' for key 'PRIMARY'然后查看了下數(shù)據(jù)庫(kù)的host信息如下：mysql> select host from user where user = 'root'+| host |+| % I| 127.0.0.1 | localhost.localdoma in |+3 rows in set (0.00 sec)host已經(jīng)有了 這個(gè)值，所以直接運(yùn)行命令：mysql>flush privileges;再用mysql administrator 連接成功！ ！遠(yuǎn)程連接時(shí)如了出現(xiàn)：INSERT INTO mysql.u

14、ser (Host,User,Password)VALUES('%','pla in ',PASSWORD('123456');ERROR 1130: is not allowed to connect to this MySQL server第一重要：查看Linux防火墻是否關(guān)掉；再來(lái)看：進(jìn)入Linux登錄Mysql :修改成%首先使用 update 把 mysql.user 中的 root 的 host 從 localhostmysql> UPDATE mysql.user SET Host='%' WHERE Host

15、='localhost' mysql>GRANT ALL PRIVILEGES ON *.* TO root"% "mysql> FLUSH PRIVILEGES ;再次連接，顯示成功。We'llFailed to get local InetAddress for VMID. This is unlikelyto matter. At all.add some extra randomn ess.UnknownHostException: p2p-8-41: p2p-8-41源碼大概是這段：public final class C3P0

16、lmplUtils trydos.write( In etAddress.getLocalHost().getAddress();catch (Excepti on e)if (logger.isLoggable(MLevel.lNFO)logger.log(MLevelNFO, "Failed to get localIn etAddress for VMID. This is uni ikely to matter. At all. We'll add some extrarandomn ess", e);dos.write( srand.n extI nt()

17、;那么：p2p-8-41是怎么得來(lái)的呢？rootp2p-8-41 #cat /etc/sysc onfig/n etworkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=p2p-8-41很明確了吧!解決方法：搜索谷歌和百度，整合一些資料：主要是因?yàn)橄到y(tǒng)沒(méi)有找到主機(jī)名p2p-8-41對(duì)應(yīng)的IP，修改Linux的hosts文件即可。具體操作步驟如下：vi /etc/hosts在行 127.0.0.1 localhost localhost.localdomain后加上 p2p-8-41 保存即可。Linux查找域名時(shí)通常指先查找文件/etc/hosts ，找不到

18、時(shí)再向 DNS效勞器請(qǐng)求。127.0.0.1localhost.localdomai n localhost p2p-8-41原因分析：Linux于host相關(guān)的幾個(gè)文件如下：/etc/host.c onf功能：指定主機(jī)名查找方法，通常指先查找文件/etc/hosts, 找不到時(shí)再向DNS效勞器請(qǐng)求。 對(duì)于大多數(shù)用戶不用改動(dòng)此文件容。Linux: /etc/host.c onf文件容order hosts, bindmulti on/etc/resolv.c onf文件功能：DNS客戶機(jī)配置文件，設(shè)置 DNS效勞器的IP地址與DNS域名相關(guān)文件：/etc/host.c onf文件格式：doma inn ame 域名search 域名n ameserver Primary