一,安装
1, 下载 mysql二进制文件: http://dev.mysql.com/downloads/mysql/ 页面,选择linux generic ,然后选择最后一个 “Linux - Generic (glibc 2.5) (x86, 32-bit), Compressed TAR Archive” 进行下载 (32或者64根据是实际情况)
2, 先创建一个group和一个属于这个组的user
shell> groupadd group1
shell> useradd -r -g group1 user1
3, 解压下载的二进制包, 到自己要放的位置, 如home/user/mysql
4, cd home/user/mysql
5, 赋予操作权限:
chown -R user1 .
chgrp -R group1 .
6, scripts/mysql_install_db --user=user1 为user1安装数据库 (需要libaio包,使用新德里帮忙下一下)
note:如果遇到[ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
那么就把刚刚解压的包中/share/english下的 errmsg.sys 拷贝过去就行
7, 赋权限:(前面加sudo)
chown -R root .
chgrp -R group1 .
chown -R root .
chown -R user1 data
8,启动mysql后台服务:
bin/mysqld_safe --user=user1 &
note:可能遇到 bin/mysqld: Can't change dir to '/var/lib/mysql/'的错误,
这个要修改解压包下的my.cnf 加上basedir和datadir 便可。
如果没有报错,那么就是服务器的启动成功。
测试一下:
新开一个terminal,
cd home/user/mysql/bin
./mysqladmin version
正确的话 就会显示版本信息之类的 并且没有其他错误报出。
二,增加安全性
cd home/user/mysql
bin/mysql_secure_installation
note:如果这里出现这么个错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
那么将/var/run/mysqld/mysqld.sock 建立一个link到 /tmp/mysql.sock就可以解决
然后具体步骤的一些 信息如下:
[b]Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success![/b]
[b]By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success![/b]
[b]Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success![/b]
三,便利设置
1,将mysql的路径加到环境变量中去:
sudo gedit /etc/profile
然后加入:
1, export MYSQL_HOME=home/user/mysql;
2,在PATH=XX后面加入 :$MYSQL_HOME/bin
1, 下载 mysql二进制文件: http://dev.mysql.com/downloads/mysql/ 页面,选择linux generic ,然后选择最后一个 “Linux - Generic (glibc 2.5) (x86, 32-bit), Compressed TAR Archive” 进行下载 (32或者64根据是实际情况)
2, 先创建一个group和一个属于这个组的user
shell> groupadd group1
shell> useradd -r -g group1 user1
3, 解压下载的二进制包, 到自己要放的位置, 如home/user/mysql
4, cd home/user/mysql
5, 赋予操作权限:
chown -R user1 .
chgrp -R group1 .
6, scripts/mysql_install_db --user=user1 为user1安装数据库 (需要libaio包,使用新德里帮忙下一下)
note:如果遇到[ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
那么就把刚刚解压的包中/share/english下的 errmsg.sys 拷贝过去就行
7, 赋权限:(前面加sudo)
chown -R root .
chgrp -R group1 .
chown -R root .
chown -R user1 data
8,启动mysql后台服务:
bin/mysqld_safe --user=user1 &
note:可能遇到 bin/mysqld: Can't change dir to '/var/lib/mysql/'的错误,
这个要修改解压包下的my.cnf 加上basedir和datadir 便可。
如果没有报错,那么就是服务器的启动成功。
测试一下:
新开一个terminal,
cd home/user/mysql/bin
./mysqladmin version
正确的话 就会显示版本信息之类的 并且没有其他错误报出。
二,增加安全性
cd home/user/mysql
bin/mysql_secure_installation
note:如果这里出现这么个错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
那么将/var/run/mysqld/mysqld.sock 建立一个link到 /tmp/mysql.sock就可以解决
然后具体步骤的一些 信息如下:
[b]Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success![/b]
[b]By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success![/b]
[b]Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success![/b]
三,便利设置
1,将mysql的路径加到环境变量中去:
sudo gedit /etc/profile
然后加入:
1, export MYSQL_HOME=home/user/mysql;
2,在PATH=XX后面加入 :$MYSQL_HOME/bin