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 人气:332
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备15002463号-1

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