Linux MySQL自己环境搭建的笔记

浏览数：29 / 时间：2015年06月12日

cd /usr/share/selinux
setenforce 0
tar -xvf MySQL-5.6.12-1.el6.x86_64.rpm-bundle.tar
rpm -qa|grep -i mysql
yum -y remove mysql-libs*
rpm -e mysql*
rpm -ivh MySQL-server-5.6.12-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.12-1.el6.x86_64.rpm
rpm -ivh MySQL-devel-5.6.12-1.el6.x86_64.rpm
rm -Rf /var/lib/mysql
cp ./usr/share/doc/MySQL-server-5.6.12/my-default.cnf /etc/my.cnf
vim /etc/my.cnf

<span style="font-family: verdana, geneva; font-size: 16px;">[client]
default-character-set = gb2312
port    = 3306
socket  = /mydata/mysql.sock
 
[mysqld]
character-set-server = gb2312
datadir = /mydata
socket  = /mydata/mysql.sock
pid-file = /mydata/mysql.pid 
key-buffer-size = 512M
user=mysql
skip-name-resolve
</span>

vim .bash_profile

<span style="font-family: verdana, geneva; font-size: 16px;">alias pp=‘ps -ef|grep mysql‘
export MYDATA_HOME=/mydata
</span>

mkdir /mydata
chown mysql:mysql -R /mydata
mysql_install_db --user=mysql --basedir=/usr --datadir=/mydata
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(‘111‘) where USER=‘root‘;
mysql> FLUSH PRIVILEGES;
mysql> quit;
pp
kill -9 xxxx
/usr/sbin/mysqld  --datadir=/mydata --pid-file=/mydata/mysql.pid &
mysql -uroot -p111
mysql> SET PASSWORD = PASSWORD(‘123‘);
mysql> show variables like ‘%char%‘;  
mysql> use mysql;
mysql> update user set host = ‘%‘ where user = ‘root‘;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.137.1‘ IDENTIFIED BY ‘123‘ WITH GRANT OPTION;
mysql> select user,host from user;