ubuntu 下配置mysql_ubuntu下安装配置MySQL

>>sudogroupadd mysql

>>sudouseradd -g mysql mysql

cd /usr/local/

>>sudotar -zxvf mysql-5.5.13-linux2.6-i686.tar.gz

>>sudo mvmysql-5.5.13-linux2.6-i686mysql

cd mysql

>>sudochown -R mysql .

>>sudochgrp -R mysql .

>>sudochown -R root .

>>sudochown -R mysql data

>>sudocp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

>>sudocp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf

2.修改my.cnf

>>sudovim /etc/my.cnf

在[mysqld]下添加

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

3.安装libaio

>>sudo apt-get install libaio1

4.初始化数据库

>>sudoscripts/mysql_install_db --user=mysql

5.启动

>>sudobin/mysqld_safe --user=mysql &

6.修改密码

>>sudobin/mysqladmin -uroot password 'root'

7.测试是否安装成功

>>sudobin/mysql -uroot -proot

9.添加环境

>>sudovim /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.配置开机启动

>>sudoupdate-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就行了