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