dagger2002
Programmer
I need to create an admin user for my mySql database.
I am using phpMyAdmin for a manager.
I am using phpMyAdmin for a manager.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create an Admin User 2
- Thread starter dagger2002
- Start date
- Status
-
1
- #2
ericbrunson
Technical User
I don't know how to do it in myphpadmin, but this isn't a myphpadmin forum. To do it using put SQL, issue the command:
grant all on *.* to newadminuser@'localhost' identified by 'theirpassword';
grant all on *.* to newadminuser@'localhost' identified by 'theirpassword';
- Thread starter
- #3
dagger2002
Programmer
I am looking for a way to do it. for my
My sql Manager is phpMyAdmin.
I want to doit any way possiable. I was wondering if their was a way to doit in sql statements or in my manager.
My sql Manager is phpMyAdmin.
I want to doit any way possiable. I was wondering if their was a way to doit in sql statements or in my manager.
ericbrunson
Technical User
What do you think I just told you?
kupe
Technical User
- Sep 23, 2002
- 376
Thanks, Eric, I've been wondering about that myself. I have mysql working well, but only with the test database. When I try a whole variety of ways to check-in, it isn't interested. So I'll be happy to try this. Cheers
paul
It's all very well hoping to get started with mysql and php, but it seems almost impossible to get both working. Very frustrating.
paul
It's all very well hoping to get started with mysql and php, but it seems almost impossible to get both working. Very frustrating.
-
1
- #6
kupe
guessing you are trying to run mysql & php on windows? if you are you might be interested in as a quick way to set up apache mysql php
this then gives you some time to learn how to configure mysql php etc..
from there it is only a short step to LAMP
guessing you are trying to run mysql & php on windows? if you are you might be interested in as a quick way to set up apache mysql php
this then gives you some time to learn how to configure mysql php etc..
from there it is only a short step to LAMP
- Thread starter
- #7
kupe
Technical User
- Sep 23, 2002
- 376
Hi Eric
I followed your advice last night -
grant all on *.* to newadminuser@'localhost' identified by 'theirpassword';
- but the best I could get was "Error 1045: Access denied for user: '@localhost'(Using password: No)
Does that mean some error by me, or ... Be grateful for advice. Cheers
paul
I followed your advice last night -
grant all on *.* to newadminuser@'localhost' identified by 'theirpassword';
- but the best I could get was "Error 1045: Access denied for user: '@localhost'(Using password: No)
Does that mean some error by me, or ... Be grateful for advice. Cheers
paul
kupe
Technical User
- Sep 23, 2002
- 376
hvass
I've searched for something like this for months. I've dowloaded xampp and can't wait to try it out tonight. If I can a c t u a l l y work with mysql, php and a server altogether ... well, I won't believe my luck. Thanks very much for the direction. Cheers paul
I've searched for something like this for months. I've dowloaded xampp and can't wait to try it out tonight. If I can a c t u a l l y work with mysql, php and a server altogether ... well, I won't believe my luck. Thanks very much for the direction. Cheers paul
ericbrunson
Technical User
The error "Access denied for user" means you aren't logged in as a user with enough privileges to create a new admin user. Do you know the password for 'mysql' or 'root' to log into mysql?
- Status
