Adding User for MYSQL Access

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Adding User for MYSQL Access

Postby tjrush » 22. July 2008 10:51

I am currently connecting to my MYSQL database using the 'root' user. However, I would like my website to connect to the database using a user with limited privileges. My question is, Where do I create this user?

Thanks,
Tom
tjrush
 
Posts: 18
Joined: 09. February 2007 11:11

Postby Wiedmann » 22. July 2008 11:19

e.g. with phpMyAdmin.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby tjrush » 22. July 2008 11:29

I understand that I have to use phpmyadmin. However, to what do I add it.

I tried adding a row to the user table in the mysql database. However, when I added that user and password to my connection script I got a MYSQL access error. I assumed that I was adding to the wrong place. Please confirm that this is the correct place to add the user or let me know where to add the user.

Tom
tjrush
 
Posts: 18
Joined: 09. February 2007 11:11

Postby Wiedmann » 22. July 2008 11:40

I understand that I have to use phpmyadmin. However, to what do I add it.

http://wiki.cihar.com/pma/user_management
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby tjrush » 22. July 2008 16:05

I new I had to use phpMyadmin, now I know how to use it. All is now well.

Thanks,
Tom
tjrush
 
Posts: 18
Joined: 09. February 2007 11:11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests