MYSQL添加新用户和数据库(命令行模式和phpmyadmin)
- font size decrease font size increase font size
- Print Email
MYSQL添加新用户和数据库(命令行模式和phpmyadmin)
一、命令行模式
首先要声明一下:一般情况下,修改MySQL密码,授权,是需要有mysql里的root权限的。
注:本操作是在WIN命令提示符下,phpMyAdmin同样适用。
用户:phplamp
用户数据库:phplampDB
1.新建用户
//登录MYSQL
@>mysql -u root -p
@>密码
//创建用户
mysql> insert into mysql.user(Host,User,Password) values('localhost','phplamp',password('1234'));
//刷新系统权限表
mysql>flush privileges;
这样就创建了一个名为:phplamp 密码为:1234 的用户。
//退出后登录一下
mysql>exit;
@>mysql -u phplamp -p
@>输入密码
mysql>登录成功
2.为用户授权
//登录MYSQL(有ROOT权限)。我里我以ROOT身份登录.
@>mysql -u root -p
@>密码
//首先为用户创建一个数据库(phplampDB)
mysql>create database phplampDB;
//授权phplamp用户拥有phplamp数据库的所有权限
@>grant all privileges on phplampDB.* to phplamp@localhost identified by '1234';
//刷新系统权限表
mysql>flush privileges;
mysql>其它操作
//如果想指定部分权限给一用户,可以这样来写:
mysql>grant select,update on phplampDB.* to phplamp@localhost identified by '1234';
//刷新系统权限表。
mysql>flush privileges;
mysql> grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
权限1,权限2,…权限n代表select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file等14个权限。
当权限1,权限2,…权限n被all privileges或者all代替,表示赋予用户全部权限。
当数据库名称.表名称被*.*代替,表示赋予用户操作服务器上所有数据库所有表的权限。
用户地址可以是localhost,也可以是ip地址、机器名字、域名。也可以用’%'表示从任何地址连接。
‘连接口令’不能为空,否则创建失败。
例如:
mysql>grant select,insert,update,delete,create,drop on vtdc.employee to This email address is being protected from spambots. You need JavaScript enabled to view it. identified by ‘123′;
给来自10.163.225.87的用户joe分配可对数据库vtdc的employee表进行select,insert,update,delete,create,drop等操作的权限,并设定口令为123。
mysql>grant all privileges on vtdc.* to This email address is being protected from spambots. You need JavaScript enabled to view it. identified by ‘123′;
给来自10.163.225.87的用户joe分配可对数据库vtdc所有表进行所有操作的权限,并设定口令为123。
mysql>grant all privileges on *.* to This email address is being protected from spambots. You need JavaScript enabled to view it. identified by ‘123′;
给来自10.163.225.87的用户joe分配可对所有数据库的所有表进行所有操作的权限,并设定口令为123。
mysql>grant all privileges on *.* to joe@localhost identified by ‘123′;
给本机用户joe分配可对所有数据库的所有表进行所有操作的权限,并设定口令为123。
3.删除用户
@>mysql -u root -p
@>密码
mysql>DELETE FROM user WHERE User="phplamp" and Host="localhost";
mysql>flush privileges;
//删除用户的数据库
mysql>drop database phplampDB;
4.修改指定用户密码
@>mysql -u root -p
@>密码
mysql>update mysql.user set password=password('新密码') where User="phplamp" and Host="localhost";
mysql>flush privileges;
mysql>quit;
二、利用phpmyadmin
1、成功登陆后的首页里填入新建的数据库名"sqlname",点击“创建”来新建数据库(如果创建不能成功,说明你没有管理权限)
2、然后点击左边工具栏上部的“主目录”,然后点击右边栏里的“权限”
3、然后点击右边栏里的“添加新用户”
4、输入数据库用户名username、主机、密码后,点击下部的“执行”(除非你添加的是管理员,否则无需设置下面的“全局权限”)。
5、然后在“按数据库指定权限”的下拉框中找到刚才添加的数据库"sqlname",选定后自动跳转到下一页面。
6、在“按数据库指定权限”里全部点选,点击“执行”确定。
7、下一页面上部出现了“您已经更新了'username'@'localhost'的权限”时,说明操作成功。
( ! ) Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169 | ||||
---|---|---|---|---|
Call Stack | ||||
# | Time | Memory | Function | Location |
1 | 0.0003 | 412672 | {main}( ) | .../index.php:0 |
2 | 0.2178 | 4263136 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.2178 | 4263136 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.6812 | 11454408 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.6818 | 11479136 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.6825 | 11534464 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.6828 | 11561864 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.6932 | 11961496 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.6932 | 11961496 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.7046 | 12612200 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.7046 | 12612200 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.7091 | 12983240 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.7119 | 13003608 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 0.8241 | 15931016 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 0.8241 | 15931016 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 0.8259 | 16103952 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |
- Published in 主机
- Read 3695 times
( ! ) Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478 | ||||
---|---|---|---|---|
Call Stack | ||||
# | Time | Memory | Function | Location |
1 | 0.0003 | 412672 | {main}( ) | .../index.php:0 |
2 | 0.2178 | 4263136 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
3 | 0.2178 | 4263136 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
4 | 0.6812 | 11454408 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
5 | 0.6818 | 11479136 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
6 | 0.6825 | 11534464 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
7 | 0.6828 | 11561864 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
8 | 0.6932 | 11961496 | K2ControllerItem->execute( ) | .../k2.php:64 |
9 | 0.6932 | 11961496 | K2ControllerItem->display( ) | .../BaseController.php:710 |
10 | 0.7046 | 12612200 | K2ControllerItem->display( ) | .../item.php:78 |
11 | 0.7046 | 12612200 | K2ControllerItem->display( ) | .../controller.php:19 |
12 | 0.7091 | 12983240 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
13 | 0.7119 | 13003608 | K2ViewItem->display( ) | .../ViewController.php:102 |
14 | 0.8241 | 15931016 | K2ViewItem->display( ) | .../view.html.php:742 |
15 | 0.8241 | 15931016 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
16 | 0.8259 | 16103952 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |