MySQL

http://www.mysql.com/

?

[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