Ubuntu下安装mysql5.5.14
系统：Ubuntu 10.04 LTSUbuntu 10.04 LTS下用apt-get install mysql-server-5.1
安装出来的是mysql版本是5.1.41-3ubuntu12.10 (Ubuntu)，版本太低我们需要的mysql event只有在mysql 5.5才支持，因此我们需要安装mysql5.5.14(mysql官方的最新稳定版本)
1. 下载
wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-client-5.5.14-1.linux2.6.x86_64.rpm
wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-devel-5.5.14-1.linux2.6.x86_64.rpm
wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-server-5.5.14-1.linux2.6.x86_64.rpm
wget http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/MySQL-shared-5.5.14-1.linux2.6.x86_64.rpm
2. 把rpm转换为deb包
apt-get install alien
alien -d MySQL-client-5.5.14-1.linux2.6.x86_64.rpm
alien -d MySQL-server-5.5.14-1.linux2.6.x86_64.rpm
alien -d MySQL-devel-5.5.14-1.linux2.6.x86_64.rpm
alien -d MySQL-shared-5.5.14-1.linux2.6.x86_64.rpm
3. 卸载原mysql
dpkg -l|grep MySQL
dpkg -P libmysqlclient16
dpkg -P mysql-common
dpkg -P mysql-client
dpkg -P mysql-devel
dpkg -P mysql-shared
dpkg -P mysql-server
4. 创建帐号
groupadd mysql
useradd -r -g mysql mysql
5. 安装
apt-get install libaio1
dpkg -i mysql-*.deb
6. 配置
mysql_install_db --user=mysql
cat > /etc/my.cnf <<EOF
# The following options will be passed to all MySQL clients
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
# The MySQL server
character-set-server=utf8
language=/usr/share/mysql/english/
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-name-resolve
#skip-locking
max_connect_errors=1000
max_connections=1000
max_allowed_packet = 10M
key_buffer = 128M
sort_buffer_size = 64M
net_buffer_length = 128K
read_buffer_size = 128M
read_rnd_buffer_size = 128M
myisam_sort_buffer_size = 128M
key_buffer_size=128M
table_open_cache=128
table_cache=128
thread_cache_size=64
query_cache_size=200M
query_cache_limit=200M
table_definition_cache=128
myisam_data_pointer_size=7
delayed_queue_size=256
preload_buffer_size=65536
delayed_queue_size=20
preload_buffer_size=1024
innodb_read_ahead_threshold=2
innodb_buffer_pool_size=128M;
innodb_additional_mem_pool=16M;
thread_concurrency = 2
quick
max_allowed_packet = 16M
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
interactive-timeout
EOF
7. 修改权限
若是前面mysql_install_db --user=mysql成功的话可以跳过这步
chown -R mysql:mysql /var/lib/mysql
8. 启动
service mysql start
创建远程帐号
[*]grant all privileges on databaseName.* to remoteUserName@'%' identified by 'testpass';
9. mysql错误解决
mysql错误日志在/var/lib/mysql/*.log里
1) 无法找到libaio.so.1
apt-get install libaio1
2) /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
这个错误产生原因是mysql运行的用户是mysql没有权限访问/var/lib/mysql，可以使用
chown -R mysql:mysql /var/lib/mysql
页:
[1]