linux安装mysql5.1_linux下安装mysql-5.1.51.tar.gz

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