【下载】
下载地址:http://dev.mysql.com/downloads/mysql/5.6.html#downloads
通用版本
解压到/usr/local/mysql目录里面
【安装】
cd /usr/local/mysql/
mkdir ./data/mysql
chown -R mysql:mysql ./
./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
cp support-files/my-default.cnf /etc/my.cnf
#修改启动脚本
vi /etc/init.d/mysqld
#修改项:
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/mysql
#启动服务
service mysqld start
service mysqld stop
service mysqld status
#加入环境变量,编辑 /etc/profile,这样可以在任何地方用mysql命令了
export PATH=$PATH:/usr/local/mysql//bin
source /etc/profile
#测试连接
mysql -uroot
# 有问题 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
vim /etc/my.cfg中修改socket = /usr/local/mysql/data/mysql/mysql.sock
【可视化访问】
MySQL WorkBench 6.3 CE
Navicat for MySQL
2. 授权法
例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;