WampServer

This is probably a dumb question. But where do I set the root password for mySQL? I can't seem to figure it out.

My too, were is the documentation?

Open phpmyadmin click Privileges on main mainu,set root password or your username with password.

root password using MySQL console

open console hit enter

mysql>
mysql>update mysql.user SET password=password("newpassword" hit enter
mysql>where user="root"; hit enter
Query OK


mysql>Flush Privileges; hit enter
Query OK
mysql>quit hit enter
mysql>bye

I always use this manual to configure WAMP:
[stanton-finley.net]
[stanton-finley.net]
Works fine for me and you have a good configured MySQL and phpMyAdmin.

Hahaha Yeah I set a MySQL root password and forgot to tell phpmyadmin about it.
That was fun for all of 10 minutes.
Then I edited the phpMyAdmin config.inc file in the c:\wamp\phpmyadmin\ and set the password for root.

(laughs again)

Cheers

First let me point out that I am fairly new to mysql and php.
Ok, here's what I've done so far.
I installed wamp without a problem. From my understanding, the default user for phpmyadmin and sql is "root" with NO password. I copied the phpbb directory into the www directory. I was able to get to phpmyadmin as well as sqlite. When I tried to run the installation for phpbb I got the message about the @localhost not being able to connect. I cleared the cache, tried again and was able to install it when I used the root user and password. However, as we know, this is not very secure so I changed the root password by performing the following from the console:


mysql>
mysql>update mysql.user SET password=password("newpassword" hit enter
mysql>where user="root"; hit enter
Query OK


mysql>Flush Privileges; hit enter
Query OK
mysql>quit hit enter
mysql>bye

I also edited the phpMyAdmin config.inc file to reflect the changed password for the root account. Now here's the part where I want to stick my head through the monitor! When I try to access the phpbb, I get the message " phpbb critical error cannot connect to database" I checked and double checked all that i've read here as well as everywhere else that google will allow me to check. WTF is going on??? No one here seems to have a valid answer either.! If someone can tell me what, precisely, it is that I can do to make this work, or at the very least tell me WHY it's doing what it is...then I'll be MORE than happy to fix the damn thing! I'm not lazy, I love to read and research but c'mon! With everyone who's using this app, no one has an answer to the same problem that I've seen posted here at least 50 times! ( and yes...I read every single one of them)!
At least I was smart enough to make a backup as soon as I was able to access the phpbb the very first time. But in order to connect again I had to ge back and reset the root paswword to the default and that's the only account I can use (for now)! So here's what I'd like to accomplish:

1. Authenticate to mysql and phpmyadmin (as well as phpbb) as a user other than root and set a password for it. And I would like to do this without having the whole damn thing blowup!
2. See item number 1!

Just trying to make it work folks...forgive my frustration please! Any help would be greatly appreciated.

You can reset the root password as instruction in this link:
[dev.mysql.com]

download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

hi all
i have installed wampserver with mysql and php

i have tried to run phpmyadmin, before that i changed the congog.inc file and added these values:
<?php
$i=0;
$i++;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; // use here your password
?>

as suggested in documentation of phpmyadmin

the problem is that i do not have any password set on the mysql server but whenever i try to run phpmyadmin it asks for the password. in the username i fill 'root' and on leaving password section "BLANK" it do not allow me to enter.....i don't have any password set so that should i enter there or where to make changes to run it smoothly.

on the other hand i am able to run mysql code without password in php files


help please

download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

It works on my localhost

Thanks

Suhas Hankare..

i have an error while
mysql> where user="root";
error is ::

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'where
user="root"' at line 1

what shud i do???

To change the root password successfully I had to add "skip-grant-tables" in my.ini (added it just below skip-networking) and restarted the server.

Used the mysql console to fire the commands:

mysql> update mysql.user set password=password("newPassword" where user="root";
mysql> flush privileges;

Remember to remove or comment out the "skip-grant-tables" afterwards, no need to have it activated for normal use.

saurabh Wrote:
-------------------------------------------------------
> i have an error while
> mysql> where user="root";
> error is ::
>
> ERROR 1064 (42000): You have an error in your SQL
> syntax; check the manual that
> corresponds to your MySQL server version for the
> right syntax to use near 'where
> user="root"' at line 1
>
> what shud i do???

I have the same problem. i am using wampserver 2.2 and can't change the password using where user

AAK!

I'm having the same problem. I reset the mySQL password using the downloaded reset files from
[downloads.jlbn.net]

then I followed the instructions from [blog.jlbn.net]

Now I'm locked out of phpMyadmin - it brings up the login box and that's it. I put in the password and it gives me another login box.

I reset the the mySQL password again and rolled back the config.inc.php and I've still got the password box popping up.

What have I missed?

thanks. it works.