非root用户安装配置mysql

mysql的安装参考这篇日志 http://blog.csdn.net/zuocheng_liu/article/details/6654694#t11

下面重点说明非root用户配置mysql，下面以用户liuzuocheng为例。

1.拷贝一个conf文件到mysql目录，cp /home/liuzuocheng/local/mysql/share/mysql/my-large.cnf /home/liuzuocheng/local/mysql/my.cnf
2.修改my.cnf的port，和mysql.sock的目录，下面是我的配置

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 83306
socket          = /home/liuzuocheng/var/mysql/mysql.sock
#
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 83306
socket          = /home/liuzuocheng/var/mysql/mysql.sock
basedir = /home/liuzuocheng/local/mysql
datadir = /home/liuzuocheng/var/mysql/data
log-error = /home/liuzuocheng/var/mysql/logs/mysql_error.log
pid-file = /home/liuzuocheng/var/mysql/mysql.pid
user = liuzuocheng

mysql> show engines; #可以看到engine的类型 
mysql> show databases; #可以看到mysql下面的数据库。

最后

以上就是坚强芒果为你收集整理的非root用户安装配置mysql的全部内容，希望文章能够帮你解决非root用户安装配置mysql所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。