1.改变mysql安装目录的拥有者
# chown -R mysql.mysql /usr/local/mysql
2.数据库初始化
# cd /usr/local/mysql/scripts
# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
3.将mysql注册为服务
# cd /usr/local/mysql/support-files
# cp mysql.server /etc/rc.d/init.d/mysql
# cp my-default.cnf /etc/my.cnf
# chkconfig --add mysql
# chkconfig mysql on
4.启动mysql服务
# service mysql start
5.修改mysql编码
# vi /etc/my.cnf在my.cnf中添加
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
[mysql]
default-character-set=utf8在my.cnf中我把”sql_model“注释掉了,因为在后边总是报错.
6.将mysql的bin加入到path中
# export PATH=/usr/local/mysql/bin:$PATH
7.设置用户名密码及远程访问
# mysql -uroot
# SET PASSWORD = PASSWORD('123456');
# GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;