Nov 21, 2009
Pages: 1, 2

Phpmyadmin Password Does Not Work

 		free web hosting

Read Latest Entries..: (Post #12) by iGuest on Oct 1 2009, 09:32 PM.
Looks great BUT... Phpmyadmin Password Does Not Work I have set up a Joomla site on localhost, using XAMPP, and the time has come to move it to the hosting server. Joomla support is pretty good, and there is no shortage of tutorials on how to do this. Most go into the 'export your database using phpMyAdmin, then FTP to server and configure using phpMyAdmin' in some depth. Unfortunately I can't start phpMyAdmin without a username/password and I have no idea what these are!  So I thought...
read more.
Read the FIRST post of this Topic. - Express your Opinion! Contribute Knowledge :-).

Open Discussion > MODERATED AREA > The Internet > Web Design

Phpmyadmin Password Does Not Work

kudmus
Sep 23 2008, 09:43 AM
I have been designing my site on my desktop using XAMPP. Everything was ok until I thought I needed a pasword for my database which did not have a password. From the day I applied the password I have been unable to access my phpMyAdmin
I type http://localhost/phpmyadmin/ and all I get is:

QUOTE

Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)


"Who said use no password?" I wonder. I have tried to clear private data in the Firefox but I ended up thinking it was not necessary because even IE which I had never used for phpMyAdmin was saying the same thing.
Of cause I could start afress and get things back the way they used to be but I won't have learnt anything. Help me so that I'll know what makes these things tick

Comment/Reply (w/o sign-up)

xpress
Sep 23 2008, 10:38 AM
usually , the default password is empty. Have you changed the password in mysql?
I mean if change your root password with command like SET PASSWORD=... etc..
then you need to change some file in phpmyadmin. Ok. Follow these steps.

1. First goto this location http://localhost/phpmyadmin/scripts
Make sure, you are running the XAMPP server.

2. There you will see setup.php file. Click on it.
You will see a page phpMyAdmin setup.

(or you can directly go to setup page with the link http://localhost/phpmyadmin/scripts/setup.php )

3. Leave it there, and go to phpmyadmin folder in your desktop.(installation directory)

4. Create a folder with name config in your phpMyAdmin directory.

5. Now goto your phpMyAdmin setup page and click on Add button located at servers.
Now you see the configuration.

6. You will see columns like Server hostname, server port etc......

Leave everthing as it is, and go to the column Password for config auth.

7. Now give your password there (the password for mysql) and click on Add button.

Now a page will open, with a message New Server added.
Many buttons are located in that page.

8. And you see a Confuration column located below in that page. It has a SAVE button.
click on it.

Now a page will appear with "File Saved" message and "Configuration saved to config/config.inc.php file.

9. OK. Now goto your config folder in phpMyAdmin directory and copy the config.inc.php file
and paste it in phpMyAdmin directory. (parent directory of config) . And delete the config directory.
(if it asks for replace, replace it)

Everything done........

Now open your phpMyAdmin page through your browser.(http://localhost/phpmyadmin/)
Hope everthing works fine.
Let me know whether it is working or not.

 

 

 


Comment/Reply (w/o sign-up)

kudmus
Sep 26 2008, 09:10 AM
Thank for the reply. I tried to follow your instructions strictly but all I get now is :
QUOTE
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I had overwriten the original config.inc.php and now I don't know how to reverse this. until I get a solution to this, I may not be able to work.

Comment/Reply (w/o sign-up)

xpress
Sep 26 2008, 10:35 AM
QUOTE(xpress @ Sep 23 2008, 04:08 PM) *
7. Now give your password there (the password for mysql) and click on Add button.


Have you set the correct password here? I mean the password you are using now to
access MySql database?

For example, can you access the database using the following command at command prompt...

CODE
C:\>mysql -u root -pyourpassword


Is it working?

Comment/Reply (w/o sign-up)

kudmus
Sep 26 2008, 02:01 PM
How do I do that? I have tried typing mysql in command prompt but it does not know what the ... that is. I have tried accessing it through the XAMPP button that says Admin. First of all I was denied access and secondly I got an error that says:
QUOTE
Access violation at address 10002593 in module 'LIBMYSQL.dll'. Read of address 00000000.

The error massage keeps appearing every few seconds.

Comment/Reply (w/o sign-up)

xpress
Sep 26 2008, 05:39 PM
Hmmm.....I don't know about this error. But I googled your error and found that lot
of people using xampp have the same problem.
QUOTE
Access violation at address 10002593 in module 'LIBMYSQL.dll'. Read of address 00000000.


And most solutions say you have to use empty password for mysql (Not a good solution, I think) to disable
popping up the above error. To do so open my.ini file and remove your password there and save the
file. But may not be the best solution. Google your problem and find solutions.....Or....

Well, Can you switch to WAMP server(Windows Apache MySql PHP) ? I have been using it and had
no problems with WAMP. Easy to setup and configure. Download WAMP server and follow default installation.
After installing it, change your root password for MySql and Follow the procedure above to setup phpMyAdmin.......

Comment/Reply (w/o sign-up)

kudmus
Sep 29 2008, 05:11 PM
You have been of great help pal. Thank you very much. Although I did not succeed I learnt a lot . Now I formated the drive and I'm going to start afresh.
QUOTE
But I googled your error and found that lot
of people using xampp have the same problem.
I also did that and found the same result.
Before formatting my drive I had another problem with transferring the site from one machine to the other I kept getting errors even after importing the whole database. the error massages had full file paths of the original locations of the files on the first machine. It was still loking for things in D:\xampp\...\fileName.php even though the site was now on drive C:\
How do I go about transferring my site in a way that will make me stay away from errors?

Comment/Reply (w/o sign-up)

xpress
Sep 30 2008, 04:27 AM
You're welcome dude. How did you transfered your website?
(I didn't understand actually, from one machine to other means,you mean from your system to
remote server ?, or within the same system?)

And, can you show me a little piece of code(at the <a href=> tag) so that I can get a clear view.
Had you checked all these links? Where do they point to?

Comment/Reply (w/o sign-up)

iGuest-DB_error
Oct 24 2008, 06:48 PM
I can log in via phpmyadmin, but not on the command line.
Phpmyadmin Password Does Not Work

Hi. I have a reversed issue, I can log in to phpmyadmin. I even created another user acct with all priv for myself, but still can not log in via command line. Which wouldn't be a big deal, but I am migrating a few really large databases that time out in IE. In addition to that - I am going from one server to another, making it all a lot easier via command line
Help anyone

-question by DB_error

Comment/Reply (w/o sign-up)

(G)bhagyesh
Mar 26 2009, 08:16 AM
No Privileges to create database
Phpmyadmin Password Does Not Work

hi,

I have installed aapserv and all went okay...

when I open phpmyadmin to create a database, it ask for me the username and password. After providing the username it enter to the phpmyadmin page but not able to create the database...

saying in red no privileges,

can some one tell me what is going wrong...Now I am downloading  xamppliteto see if it work withit.

 bpatel

-reply by bhagyesh

Comment/Reply (w/o sign-up)

Latest Entries

iGuest
Oct 1 2009, 09:32 PM
Looks great BUT...
Phpmyadmin Password Does Not Work

I have set up a Joomla site on localhost, using XAMPP, and the time has come to move it to the hosting server.

Joomla support is pretty good, and there is no shortage of tutorials on how to do this. Most go into the 'export your database using phpMyAdmin, then FTP to server and configure using phpMyAdmin' in some depth. Unfortunately I can't start phpMyAdmin without a username/password and I have no idea what these are! 

So I thought this tutorial would tell me what I need to do. Great!

--

1. First goto this location http://localhost/phpmyadmin/scripts
Make sure, you are running the XAMPP server.

This gives me a 403 (access forbidden, new XAMPP security concept).

--

2. There you will see setup.Php file. Click on it.
You will see a page phpMyAdmin setup.

(or you can directly go to setup page with the link http://localhost/phpmyadmin/scripts/setup.Php )

This gives me a 404 (object not found) error.

-- 

Can anybody give me some pointers as to what is happening> 

thanks in advance! 

-reply by Mike

Comment/Reply (w/o sign-up)

iGuest
Aug 14 2009, 01:30 PM

to access mysql when you have XAMPP installed is different from a stanandard mysql installation. This is how it's done:

1. Open up CMD

2. Go to (your XAMPP installation directory)/mysql/bin

3. Type: mysql -u root -p

4. Give your password


Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Pages: 1, 2
Similar Topics

Keywords : phpmyadmin, password, work

  1. Accessing Password-protected Urls
    Tryin' to figure out access... (4)
  2. What If You Forget Mysql Root Password
    (2)
    If you have set a root password, but forgot what it was, you can set a new password with the
    following procedure: 1. Take down the mysqld server by sending a kill (not kill-9) to the mysqld
    server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory:
    shell> kill `cat /mysql-data-directory/hostname.pid` You must be either the Unix root user or the
    same user mysqld runs as to do this. 2. Restart mysqld with the --skip-grant-tables option. 3. Set
    a new password with the mysqladmin password command: shell> mysqladmin -u root password &....
  3. Phpmyadmin
    (4)
    Hello, I need a bit of help. (Oh great, here we go again with a newb) The question is, as a
    free-hosted site, do I have access to phpMyAdmin? If not, I'd like to install it. Is there any
    problem with that? If you don't know what phpMyAdmin is, It's your best friend if you use
    php and databases. It's a web-based, visual database manager, and it's god. Thanks....
  4. Password Protected...
    (1)
    How can you make a page (or several pages) protected with a password or with different usernames and
    passwords, using query strings? please give me some helpful scripts or names of programs. On the
    section of password protection i really *BLEEP* /unsure.gif" style="vertical-align:middle"
    emoid=":unsure:" border="0" alt="unsure.gif" /> . I always use a script that does "name".htm, but it
    sux so .......


      5. Looking for phpmyadmin, password, work

Searching Video's for phpmyadmin, password, work
See Also,
advertisement


Phpmyadmin Password Does Not Work

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com