ubuntu下安装配置MySQL

榕叶

　　1.解压mysql

>>sudo groupadd mysql
>>sudo useradd -g mysql mysql
cd /usr/local/
>>sudo tar -zxvf mysql-5.5.13-linux2.6-i686.tar.gz
>>sudo mv mysql-5.5.13-linux2.6-i686 mysql
cd mysql
>>sudo chown -R mysql .
>>sudo chgrp -R mysql .
>>sudo chown -R root .
>>sudo chown -R mysql data
>>sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
>>sudo cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf

2.修改my.cnf
>>sudo vim /etc/my.cnf
在[mysqld]下添加
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

3.安装libaio
>>sudo apt-get install libaio1

4.初始化数据库
>>sudo scripts/mysql_install_db --user=mysql

5.启动
>>sudo bin/mysqld_safe --user=mysql &

6.修改密码
>>sudo bin/mysqladmin -uroot password 'root'

7.测试是否安装成功
>>sudo bin/mysql -uroot -proot

9.添加环境
>>sudo vim /etc/environment
添加：/usr/local/mysql/bin

>>source /etc/environmentch

9.配置远程登录
>>mysql  -uroot -proot
mysql> use mysql
Database changed
mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | ubuntu    |                                           |
| root | 127.0.0.1 |                                           |
| root | ::1       |                                           |
|      | localhost |                                           |
|      | ubuntu    |                                           |
+------+-----------+-------------------------------------------+
6 rows in set (0.00 sec)

mysql> delete from user where host!='localhost';
Query OK, 4 rows affected (0.00 sec)

mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
|      | localhost |                                           |
+------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)

mysql> delete from user where user!='root';
Query OK, 1 row affected (0.00 sec)

mysql> update user set host='%';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select user,host,password from user;
+------+------+-------------------------------------------+
| user | host | password                                  |
+------+------+-------------------------------------------+
| root | %    | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------+------+-------------------------------------------+
1 row in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

10.配置开机启动
>>sudo update-rc.d mysqld defaults


若启动mysql失败，原因如下：
# /etc/rc.d/init.d/mysqld startStarting MySQL.Manager of pid-file quit without updating file.[失败]
解决办法：配置的时候有一个步骤是 cp support-files/my-medium.cnf /etc/my.cnf ; 就编辑my.cnf,在[mysqld]下面加上：datadir = /usr/local/mysql/data 例如# The MySQL server[mysqld]port            = 3306socket          = /tmp/mysql.sockskip-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_s ...
                       
2.首先到/usr/local/mysql/data先 chown -R mysql:mysql * 然后杀掉mysql进程，在启动musql就行了