Try using localhost instead of 127.0.0.1, also if you are hosting elsewherem check that your host doesn't require a specific address writing there (mine does).
Andrew
Access Denied
Moderators: egami, macek, gesf
-
- New php-forum User
- Posts: 6
- Joined: Sun Oct 10, 2004 6:13 am
- Location: Rowlett, Texas
- Contact:
I have the same issue exactly.
Installing on a system with windows xp / norton internet security. I have tried several versions of mysql. Still cant connect after successful installation. :shock:
I tried the grant privlege * thingie, and even created a new user through phpMyAdmin.
When I tried version 4.1.5, after successful upload and using phpMyAdmin, (config, username, user password) when I got the popup window for the user name and password, nothing I entered was accepted. You could try it 3 times then got a screen change - access denied. :shock:
In one case, the only version I could connect on (phpMyAdmin) was 4.0.0a. When I wrote the db via php form, it would not show the result although it actually wrote the data to the db.
I did removed norton and did a restore back to july. No luck :shock:
Is this an OS issue? or ?? Any help would be greatly appreciated.
Kind regards,
Big Al - Rowlett, Texas
Installing on a system with windows xp / norton internet security. I have tried several versions of mysql. Still cant connect after successful installation. :shock:
I tried the grant privlege * thingie, and even created a new user through phpMyAdmin.
When I tried version 4.1.5, after successful upload and using phpMyAdmin, (config, username, user password) when I got the popup window for the user name and password, nothing I entered was accepted. You could try it 3 times then got a screen change - access denied. :shock:
In one case, the only version I could connect on (phpMyAdmin) was 4.0.0a. When I wrote the db via php form, it would not show the result although it actually wrote the data to the db.

I did removed norton and did a restore back to july. No luck :shock:
Is this an OS issue? or ?? Any help would be greatly appreciated.
Kind regards,
Big Al - Rowlett, Texas
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
this is really weird because ites surely not an OS issue...
try installing phpMyAdmin 2.6.0 pl1 even thou all other versions are working fine..
dont forget to set some variables in the config.inc.php file.
The main problem is that you are using a root as a username for the entire DB engine..
change the username and a password in MySQLAdmin that is distributed with the MySQL and then set those username and a password in the phpMyAdmin's config.inc.php file..
This will work... or atleast should work... you might have already done that before,,, but try again.. with a aclean install... i would set an Auth method to HTTP if i were you..
good luck guys
mail me if something is not working
try installing phpMyAdmin 2.6.0 pl1 even thou all other versions are working fine..
dont forget to set some variables in the config.inc.php file.
The main problem is that you are using a root as a username for the entire DB engine..
change the username and a password in MySQLAdmin that is distributed with the MySQL and then set those username and a password in the phpMyAdmin's config.inc.php file..
This will work... or atleast should work... you might have already done that before,,, but try again.. with a aclean install... i would set an Auth method to HTTP if i were you..
good luck guys

mail me if something is not working
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
Okej... i found out that ive made one mistake**atleast** while explaining..
http and cookie types of access do not need a password in the config.inc.php... only the congig type does..
Also i forgot to tell thats its very important to set blowfish secret.
So im not really sure what kind of error you are getting... i need to see that with my own eyes or you sjould paste© them here..
But it sounds to me that you might've forgoten to save settings/reload mysql after changing the pass/username.
Try doing that..
http and cookie types of access do not need a password in the config.inc.php... only the congig type does..
Also i forgot to tell thats its very important to set blowfish secret.
So im not really sure what kind of error you are getting... i need to see that with my own eyes or you sjould paste© them here..
But it sounds to me that you might've forgoten to save settings/reload mysql after changing the pass/username.
Try doing that..
-
- New php-forum User
- Posts: 6
- Joined: Sun Oct 10, 2004 6:13 am
- Location: Rowlett, Texas
- Contact:
Well......... I removed the version I was trying to install. Went to 4.1.5.
btw: I am using XP Professional.
When I ran the setup utility, it said that it could not create windows service for mysql; error:0
I got it to install by setting the service up in XP's view network connecitons utility. Here is where I went and what I did.
Start>networkplaces>view network connections
right click on local area connection
click on properties
Click Advanced tap
Make sure that the Protect my computer and network......
box is checked. Then click on the setting button at the
bottom of this window.
Check the Web Server (HTTP) box.
Click OK
Rebooted the computer and sucessfully installed 4.1.5.
Although I STILLhave the access denied error :shock:
Again, THANK YOU, Alexei, for your efforts. They were more than appreciated.
Kind regards,
G. Allen Cummings
Rowlett, Texas
btw: I am using XP Professional.
When I ran the setup utility, it said that it could not create windows service for mysql; error:0
I got it to install by setting the service up in XP's view network connecitons utility. Here is where I went and what I did.
Start>networkplaces>view network connections
right click on local area connection
click on properties
Click Advanced tap
Make sure that the Protect my computer and network......
box is checked. Then click on the setting button at the
bottom of this window.
Check the Web Server (HTTP) box.
Click OK
Rebooted the computer and sucessfully installed 4.1.5.
Although I STILLhave the access denied error :shock:
Again, THANK YOU, Alexei, for your efforts. They were more than appreciated.
Kind regards,
G. Allen Cummings
Rowlett, Texas
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
I think they wrote about using a command line... and it worked for them...
i think its just their configuration files that have some misstakes... this i was able to understand from one of the emails that i recieved.
If some of you would post their config files --- atleast a part of it..
then i might be able to help a bit more...
i think its just their configuration files that have some misstakes... this i was able to understand from one of the emails that i recieved.
If some of you would post their config files --- atleast a part of it..
then i might be able to help a bit more...
-
- New php-forum User
- Posts: 6
- Joined: Sun Oct 10, 2004 6:13 am
- Location: Rowlett, Texas
- Contact:
Hi guys,
First of all, I solved the "no access" error as mentioned in my last post. It was related to the config of my OS.
Now I get "incorrect user/password" error.
command line works just fine. Did the grant all and everything else in the manual.
It should be noted that when I set the config.inc.php file for phpMyAdmin [latest version] type = 'config' and user = 'root and password = ''[nothing], I can access MySql.
It's when I put anything else in the username and password [as shown by the admin utility that comes with MySql] that I get the "password/user" incorrect error.
FYI - I didn't have any issues when using Win 2000 prof edition. This XP prof edition has not been what I thought. When originally installed, the installer suggested to use the upgrade option, which I did. Lots of issues. I wound up wiping the drive and doing a clean install with XP. I don't know if this XP is cracked up to be what Microsoft said it was......... anyway...... :sad:
:-D Again, thanks to all for the posts. I appreciate your input and kindness.
Kind regards,
G. Allen Cummings
Rowlett, Texas
First of all, I solved the "no access" error as mentioned in my last post. It was related to the config of my OS.
Now I get "incorrect user/password" error.
command line works just fine. Did the grant all and everything else in the manual.
It should be noted that when I set the config.inc.php file for phpMyAdmin [latest version] type = 'config' and user = 'root and password = ''[nothing], I can access MySql.
It's when I put anything else in the username and password [as shown by the admin utility that comes with MySql] that I get the "password/user" incorrect error.
FYI - I didn't have any issues when using Win 2000 prof edition. This XP prof edition has not been what I thought. When originally installed, the installer suggested to use the upgrade option, which I did. Lots of issues. I wound up wiping the drive and doing a clean install with XP. I don't know if this XP is cracked up to be what Microsoft said it was......... anyway...... :sad:
:-D Again, thanks to all for the posts. I appreciate your input and kindness.
Kind regards,
G. Allen Cummings
Rowlett, Texas
-
- New php-forum User
- Posts: 6
- Joined: Sun Oct 10, 2004 6:13 am
- Location: Rowlett, Texas
- Contact:
OK.......... I set type = 'http' user to 'username' and password to ' '
When the popup window came up, I only put the username.....nothing in the password and got access.
What a deal....... :grin:
G. Allen Cummings
Rowlett, Texas
When the popup window came up, I only put the username.....nothing in the password and got access.
What a deal....... :grin:
G. Allen Cummings
Rowlett, Texas
- Alexej Kubarev
- Site Admin
- Posts: 2213
- Joined: Fri Mar 05, 2004 7:15 am
- Location: Täby, Stockholms län
- Contact:
Well the deal is that in the config file you should set the MySQL access information... the one that is set in my.ini file of the mysql database administration..
Http access type needs only username to be saved in the phpmyadmin config.inc.php
After you've loged in you should create a new user and give it full access with a password protection... this way you will have to use that user instead..
;-)
Http access type needs only username to be saved in the phpmyadmin config.inc.php
After you've loged in you should create a new user and give it full access with a password protection... this way you will have to use that user instead..
;-)
-
- New php-forum User
- Posts: 6
- Joined: Sun Oct 10, 2004 6:13 am
- Location: Rowlett, Texas
- Contact:
THANK YOU, Alexei. Your suggestion will be utilized.
Again, I appreciate your effort in helping me with this issue.
Kind regards,
G. Allen Cummings
Rowlett, Texas
Websites:
[url]http://www.isaaccummingsfamily.org][/url]
http://www.estructuredweb.com/tartanday/
http://www.grandlodgeoftexas.org
http://www.easttrinity.com
Again, I appreciate your effort in helping me with this issue.
Kind regards,
G. Allen Cummings
Rowlett, Texas
Websites:
[url]http://www.isaaccummingsfamily.org][/url]
http://www.estructuredweb.com/tartanday/
http://www.grandlodgeoftexas.org
http://www.easttrinity.com