標(biāo)簽:
mysql數(shù)據(jù)庫tar.gz安裝雜談 |
分類: Mysql數(shù)據(jù)庫 |
MySQL ? [user@localhost 桌面 ]$ ls mysql-5.1.51.tar.gz mysql-5.1.51.tar.gz [user@localhost 桌面 ]$ su 密碼: [root@localhost 桌面 ]# cp mysql-5.1.51.tar.gz /usr/local/src/ [root@localhost 桌面 ]# cd /usr/local/src/ [root@localhost src]# groupadd -r mysql [root@localhost src]# useradd -g mysql -r mysql [root@localhost src]# gunzip < mysql-5.1.51.tar.gz | tar -xvf - [root@localhost src]# cd mysql-5.1.51/ [root@localhost mysql-5.1.51]# ./configure –prefix=/usr/local/mysql/ [root@localhost mysql-5.1.51]# make [root@localhost mysql-5.1.51]# make install [root@localhost mysql-5.1.51]# cd /usr/local/mysql/ [root@localhost mysql]# chown -R mysql . [root@localhost mysql]# chgrp -R mysql . [root@localhost mysql]# /usr/local/mysql/bin/mysql_install_db --user=mysql Installing MySQL system tables... OK Filling help tables... 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 localhost.localdomain 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 with the /usr/local/mysql/bin/mysqlbug script! ? [root@localhost mysql]# chown -R root . [root@localhost mysql]# chown -R mysql /usr/local/mysql/var/ [root@localhost mysql]# cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf [root@localhost mysql]# cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysql.server [root@localhost mysql]# /usr/local/mysql/bin/mysql -V /usr/local/mysql/bin/mysql Ver 14.14 Distrib 5.1.51, for pc-linux-gnu (i686) using EditLine wrapper [root@localhost mysql]# /etc/init.d/mysql.server status MySQL is not running [ 失敗 ] [root@localhost mysql]# /etc/init.d/mysql.server start Starting MySQL. [ 確定 ] [root@localhost 桌面 ]# /etc/init.d/mysql.server status MySQL running (3464) [ 確定 ] [root@localhost mysql]# /usr/local/mysql/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.51-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> exit ? ? Bye |
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯(lián)系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長非常感激您!手機(jī)微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
