赞
踩
sudo /etc/init.d/mysql stop
sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld
sudo /usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root
use mysql
update user set authentication_string=PASSWORD("888888") where User='root';
#sudo /etc/init.d/mysql start
mysql.h: No such file or directory
sudo apt-get install libmysql+±dev
编译时须要加连接-lmysqlclient.
一、 创建mysql数据库
CREATE DATABASE IF NOT EXISTS testdb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
二、创建用户
1.新建用户
–创建了一个名为:test 密码为:1234 的用户
create user 'test'@'localhost' identified by '1234';
注意:
此处的"localhost",是指该用户只能在本地登录,不能在另外一台机器上远程登录。如果想远程登录的话,将"localhost"改为"%",表示在任何一台电脑上都可以登录。也可以指定某台机器可以远程登录。
select user,host from mysql.user;
drop user test@localhost ;
drop user test@'%';
set password for test = password('1122');
update mysql.user set password=password('1234') where user='test'
–刷新
flush privileges;
grant all privileges on 'testdb'.* to 'test'@'%' identified by '1234';
flush privileges;
grant create,alter,drop,select,insert,update,delete on testdb.* to test@'%';
6.查看用户权限
show grants for test;
flush privileges;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。