Ubuntu系统下手动安装mysql及开启外部访问
(虽然apt-get方式安装方便快捷,不喜欢文件散落到各个约定的目录里,喜欢完全地控制,安装在同个目录内,需要mysql服务时,手动启动,暂不用时节省资源。)
1. 下载: 从mysql网站下载linux版本 http://downloads.mysql.com/archives.php,在此以mysql-5.6.10版本为例。
2. 解压到相应目录,可以解压到home目录下。官方建议安装mysql 需要建立mysql用户组和用户,如果您想按官方的来安装,可参与目录下的INSTALL-BINARY的文件,教您如何在shell下安装,如下:
groupadd mysql useradd -r -g mysql mysql cd /usr/local tar zxvf /path/to/mysql-VERSION-OS.tar.gz ln -s full-path-to-mysql-VERSION-OS mysql cd mysql chown -R mysql . chgrp -R mysql . scripts/mysql_install_db --user=mysql chown -R root . chown -R mysql data# Next command is optional cp support-files/my-medium.cnf /etc/my.cnf bin/mysqld_safe --user=mysql &# Next command is optional cp support-files/mysql.server /etc/init.d/mysql.server
tar -zxvf /path/to/mysql-VERSION-OS.tar.gz
cd mysqlscripts/mysql_install_db --user=lyh
sudo apt-get install libaio1
./support-files/mysql.server start
./bin/mysqladmin -u root -h 127.0.0.1 -p password '123456'
export PATH=/home/lyh/softs/mysql/bin:$PATH >> ~/.bashrc
sudo cp support-files/mysql.server /etc/init.d/mysql.server
mv Download/mysql-VERSION-OS.tar.gz softscd softstar -zxvf mysql-VERSION-OS.tar.gzln -s mysql-VERSION-OS mysqlcd mysqlscripts/mysql_install_db --user=lyh sudo apt-get install libaio1 (如有需要)
cd /usr/local sudo tar zxvf /path/to/mysql-VERSION-OS.tar.gz sudo ln -s mysql-VERSION-OS mysql cd mysql sudo chown -R lyh . sudo chgrp -R lyh . scripts/mysql_install_db --user=lyh sudo apt-get install libaio1 (如有需要)
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';mysql> flush privileges;