程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> mysql修改root密碼,分配權限

mysql修改root密碼,分配權限

編輯:MySQL綜合教程

mysql修改root密碼,分配權限   1.如我的Mysql 安裝在E:\xampp\mysql目錄下 win7下使用CMD,命令行使用無密碼的root用戶登錄mysql數據庫,紅色字體為命令 1).更新root用戶密碼為root 2.)刷新權限 3).分配root用戶在任何主機上都可以訪問mysql數據庫 4).刷新權限   E:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 41 Server version: 5.5.25a MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> update mysql.user set password=PASSWORD('root') where user='root'; Query OK, 2 rows affected (0.00 sec) Rows matched: 2  Changed: 2  Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to 'root'@'%' identified by 'root' with grant  option; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye   2.使用修改過得root用戶密碼root登錄Mysql   E:\xampp\mysql\bin>mysql -uroot -p Enter password: **** Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 42 Server version: 5.5.25a MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | cdcol              | | mysql              | | oms                | | performance_schema | | phpmyadmin         | | test               | | webauth            | +--------------------+ 8 rows in set (0.00 sec) mysql>

 

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved