Ubuntu中MySQL安装与使用笔记

页面导航:首页 > 数据库 > Mysql > Ubuntu中MySQL安装与使用笔记

Ubuntu中MySQL安装与使用笔记

来源: 作者: 时间:2016-02-21 09:46 【

Ubuntu中MySQL安装与使用笔记mysql安装$ sudo apt-get install mysql-server mysql-clientmysql服务器启动、关闭和重启$ sudo /etc/init.d/mysql start/stop/restart设置初始密码$ mysqladmin -u roo...
Ubuntu中MySQL安装与使用笔记
 
mysql安装
$ sudo apt-get install mysql-server mysql-client
 
mysql服务器启动、关闭和重启
$ sudo /etc/init.d/mysql start/stop/restart
 
设置初始密码
$ mysqladmin -u root -p password 你的密码
 
修改密码
$ mysqladmin -u root -p password 你的新密码
(终端会提示输入原始密码)
Enter password:
 
mysql登录本地服务器(例如登录root用户)
$ mysql -uroot -p
或者:
Enter password:
$ mysql -hlocalhost -uroot -p
 
mysql登录远程服务器(例如登录root用户)
$ mysql -h hostname/ip -P portnum -uroot -p  
Enter password:
注意-P(大写)指定端口号,该参数可以省略,省略后将连接默认端口3306.
 
创建新用户及设置权限(GRANT命令)
GRANT可以用来创建用户并同时设置权限,也可以对已有用户设置或者修改权限,使用方法相似,GRANT的格式如下:
grant <privileges> on 对象(database.table) to 用户([email protected]) [IDENTIFIED BY "<password>"] [WITH GRANT OPTION];
(1)如果指定了IDENTIFIED BY "<password>",[email protected]定权限<privileges>,[email protected]<privileges>,若密码与原始密码不一致,还会修改成新的密码。因此指定了IDENTIFIED BY,GRANT可以创建用户、修改密码、指定权限等;
(2)如果没有指定IDENTIFIED BY,GRANT可以用来指定权限,也就是设置或者修改权限是不用指定密码的;
(3)<privileges>字段可以指定为"ALL PRIVILEGES"表示所有权限,或者其他指定的多个以逗号隔开的权限字段;
(4)database.table字段表示某个数据库的某个表,*.*表示所有的数据库的所有表,dbname.*表示数据库dbname的所有表;
(5)[email protected][email protected],user@"%"表示user用户可以从任意主机访问,user@'192.168.0.1'表示用户user只能从指定主机访问。
例子:
For creating a new user with all privileges (use only for troubleshooting), at prompt type:
$ mysql> GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
 
For creating a new user with fewer privileges (should work for most web applications) which can only use the database named "database1", at mysql prompt type:
$ mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON database1.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword';
yourusername and yourpassword can be anything you like. database1 is the name of the database the user gets access to. localhost is the location which gets access to your database. You can change it to '%' (or to hostnames or ip addresses) to allow connections from every location (or only from specific locations) to the database. Note, that this can be a security problem and should only be used for testing purposes!
【关于GRANT的详细用法可以从网上查看相关资料】
 
查看用户权限
$ mysql> show grants for [email protected];
$ mysql> show grants for user; 等价于:$ mysql> show grants for user@"%";
 
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<