1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

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

Discussion in '后端开发' started by OUYANG, Sep 13, 2005.

  1. OUYANG

    OUYANG New Member

    Joined:
    Sep 6, 2005
    Messages:
    3,025
    Likes Received:
    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

    Joined:
    Sep 6, 2005
    Messages:
    10,580
    Likes Received:
    36
    知道了....
     
  3. waistcoat

    waistcoat New Member

    Joined:
    Sep 12, 2005
    Messages:
    1,312
    Likes Received:
    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

    Joined:
    Sep 9, 2005
    Messages:
    653
    Likes Received:
    1
    去装个phpmyadmin更方便撒