XAMPP change the default password for mysql

MySQL's "root" user by default is no password, so in PHP you can use mysql_connect ("localhost", "root ","") to connect to MySQL server;
If you want to in MySQL "root" user to set a password, please use the console "mysqladmin" command. For example:

\ ... \ Xampp \ mysql \ bin \ mysqladmin-u root password secret

Please note that you change the root password, do not forget to change the information in PHPMyAdmin. In \ ... \ xampp \ phpmyadmin \ search under "config.inc.php" and edit the following lines:

$ Cfg ['Servers'] [$ i] ['user'] = 'root'; / / MySQL SuperUser
$ Cfg ['Servers'] [$ i] ['auth_type'] = 'http'; / / HTTP MySQL authentification

From now on, need to correctly enter "root" password to start PHPMyAdmin

Original Address: http://www.apachefriends.org/zh_cn/xampp-windows.html

分类:Database 时间:2011-08-09 人气:353
blog comments powered by Disqus


  • PhpMyAdmin root password change problem Access denied for user 'root' @ 'localhost' (using password 2011-05-06

    I just started to give out a Mysql played rough, full finished the other day after the database installation manual modified the root user's password, and then re-login with root user is all OK. But when it landed again today reported 1045 error code

  • Changes and to solve the Mysql root password in several ways 2011-05-05

    A method using phpmyadmin, this is the most simple, and modify the mysql database user table, but do not forget to use the PASSWORD function. Second method used mysqladmin, which is a special case of the previous declarations. mysqladmin-u root-p pas

  • [Reserved] setting. Modification. Mysql root password reset 2010-03-16

    Set, modify, reset mysql root password Overview: This article describes how to set up, modify, reset (if you do not care forget root password) mysql root password, and often I use the mysqladmin command, often appear similar to the following informat

  • Get back in the vps host mysql server root password 2010-03-16

    Overview: Recently, a vps customers configure LAMP in time, modify the mysql server root password, a few days forgot your password, ask me how to get it back, Now I will elaborate in detail how to recover root password, at the two case, a mysql datab

  • MySQL root password in many ways changes 2010-06-22

    Method 1: Use SET PASSWORD command mysql-u root mysql> SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ('newpass'); Method 2: Using mysqladmin mysqladmin-u root password "newpass" If the root password has been set, using the following method

  • Mysql5.0 root password forgotten solution 2010-08-02

    Using this method, the root password successfully solved the problem, version 5.0.24a-community-nt Step 1. Stop mysql service (the first in the "Task Manager" to end the "mysql-nt.exe" program) Some say that the Internet can open a com

  • Changes on the mysql root password under linux problems encountered 2010-08-03

    Changes on the mysql root password under linux processes, can be found online a lot, probably is: # Killall mysqld / / interrupt the process currently running mysql # Mysqld_safe - skip-grant-tables & / / start in Safe Mode # Mysql / / no direct acce

  • Mysql root password change 2010-10-10

    Mysql today made a experiment on the console when I use mysql-u root-p command when an error such ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES) Means that the initial root password is empty approach: # Mysql-u

  • linux system mysql database root password to modify the method 2011-05-12

    The first method: / Local / server / mysql / bin / mysqladmin-u root password 'new_password' When the mysql installation, the default is no root password, use this method to set the installation root password. [Root @ uc ~] # / local / server / mysql

  • MySQL Change root password of various finishing methods 2011-07-21

    Finishing the four changes in the MySQL root password in the method may be helpful to everyone! Method 1: Use SET PASSWORD command mysql-u root MySQL> SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ('newpass'); Method 2: using mysqladmin mysqladmin

iOS 开发

Android 开发

Python 开发



PHP 开发

Ruby 开发






Javascript 开发

.NET 开发



Copyright (C) codeweblog.com, All Rights Reserved.

CodeWeblog.com 版权所有 闽ICP备15018612号

processed in 0.039 (s). 12 q(s)