1. 论坛系统升级为Xenforo,欢迎大家测试!
    排除公告

PHP菜鸟 学习了下MYSQL ROOT 密码更改

本帖由 OUYANG2005-09-13 发布。版面名称:后端开发

  1. OUYANG

    OUYANG New Member

    注册:
    2005-09-06
    帖子:
    3,025
    赞:
    5
    以下笔记:

    开始-程序-附件-命令提示符

    c:>cd \appserv\mysql\bin

    c:\appserv\mysql\bin:>mysql -u root

    mysql>use mysql;

    mysql>update user set password=password('XXXXXXX') where user='root';

    mysql>FLUSH PRIVILEGES;

    mysql>\q

    呵呵完成,下面测试下

    c:\appserv\mysql\bin:>mysql -u root -p

    Enter password: ******

    Welcome to.....................


    MYSQL 到这下载吧 http://dev.mysql.com/downloads/
     
  2. 老林

    老林 New Member

    注册:
    2005-09-06
    帖子:
    10,580
    赞:
    36
    知道了....
     
  3. waistcoat

    waistcoat New Member

    注册:
    2005-09-12
    帖子:
    1,312
    赞:
    11
    kill `cat /mysql-data-directory/hostname.pid`
    --skip-grant-tables'
    'mysqladmin -h hostname -u user password 'new password''
    `mysqladmin -h hostname flush-privileges' ,or SQL cammand:`FLUSH PRIVILEGES'

    我到底在说些什么.. 郁闷
     
  4. xooass

    xooass New Member

    注册:
    2005-09-09
    帖子:
    653
    赞:
    1
    去装个phpmyadmin更方便撒