mysql操作

mysql启动:

  mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --datadir=/var/lib/mysql

mysql关闭:

  mysqladmin -S /tmp/mysql${port}.sock shutdown  -u$user -p$password

创建系统表:

  mysql_install_db --user=mysql --datadir=/var/lib/mysql/

修改mysql的端口:

  修改/etc/my.cnf文件,在[mysqld]下 添加 port=3303

mysql操作

[mysqld]
datadir=/var/lib/mysql3303
socket=/var/lib/mysql3303/mysql.sock
port=3303
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld3303.log
pid-file=/var/run/mysqld/mysqld3303.pid
~

mysql操作

 访问mysql:

  mysql -S /var/lib/mysql3303/mysql.sock -P 3303  -u user -p

创建数据库的用户:

  GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO repl@‘192.168.0.%‘ IDENTIFIED BY ‘p4ssword‘;

  GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;

   flush privileges;

mysql操作,布布扣,bubuko.com

mysql操作

上一篇:ubuntu13安装mysql(转)


下一篇:(父母篇)父母如何妙用自然光拍摄新生儿造型指南教程