Allaclone Mysql Error: Access denied for user 'root'@'localhost' (using password:YES)
The Error i get when trying to navigate to _____.com/allaclone
Code:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\AppServ\www\AllaClone\includes\config.php on line 97 Code:
<?php |
Pretty sure that error comes up when you don't set the database info in the php config file.
Getting this to work can be tricky if you don't know anything about php or apache (if you're using that.) U |
Quote:
|
I'm not at home to check on my server computer atm..but isn't there a config.php file as well? Php shouldn't use
the *.dist file unless you rename it. Renaming an extension in windows can be tricky. You'll have to turn on 'show file extensions' under folder options. Then you can change the file name and delete the '.dist' if you don't already have a file with the new name. U |
It has both a php and php.dist the only other php is like menu.php or whatnot.
I made the changes to both of the files to be safe and still no dice. :( |
I'll post the changes that I made to mine later this evening if no one has suggested a fix yet. There's still several things it could be
regarding php and apache versions, though I don't think you would get that far with a version-related issue. Try changing 'localhost' to '127.0.0.1' and see if that helps. U |
|
Quote:
Any ideas anyone? :confused: |
Bumping it is not going to win you any friends and might result in whoever could help you choosing not to. If someone hasn't seen it and they read new messages they will, be patient.
|
Quote:
on the original note - as an update: i'm still open to any suggestions onto what the problem listed above is but I think it has to do with mysql ; last time i had a problem like this it was to do with starting the server and it was something small and benign - wish i could remember what it was, in the long range, this may or may not be the same thing. :S I had a second install or magelo and it gave me a database error but didnt give me the error. in all cases mysql wont let that user in, when i tried to grant user all privs it said i had a database error or something. syntax error. |
check php.ini -> extension=php_mysql.dll
|
(A little overkill, but helpful to anyone searching in the future.)
You can always use the root:Password combo for testing and then switch back to the limited-access client once it works. It is something small..and php install doesn't seem to make all three of the needed apache line additions..just the two. If you're using apache/php, make sure that you have the compatible versions of each based on the OS that you're using. (Apache Lounge has the VC6 build that is compatible with 32-bit Win OS's..and make sure you read up on using the thread-safe versus non-thread safe versions of apache.) If you're getting the 'can't load' certain module errors, this website gives a decent idea of what php options need to be checked on install: http://www.websiteadministrator.com....hp533_pg5.html Apache needs to properly configure as well, and I'm assuming that you have that right. You should be able to access the default 'index.html' if apache is working. However, when installing php, the installer only makes these changes to the apache config file: Code:
#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL Code:
PHPIniDir "C:/PHP" troubleshooting I had to do. Not sure if that is absolutely needed, but doesn't break it.) Let us know if any of this helped or if you're still having issues. (Don't forget to restart the server once you make the config changes.) U |
What OS are you on, Windows or Linux? Also, have you tried using a tool like Navicat that you can try connecting to your database with to verify your connection info is correct? If it doesn't work for Navicat with the same info, it probably won't work for AllaClone.
Also, I would recommend creating a new user in MySQL for the AllaClone. You can restrict the new account to SELECT only to reduce security risks. |
Quote:
I got this error when trying to make give root all privs AND when trying to create a new user :(. Btw where was i supposed to make the changes shown in the last codebox? the php config file didnt have anything like that in there. Quote:
Windows 7 Home Premium 64 Bit. There are TWO mysqls (seems unnecasary but it was how i knew how to run this properly with what was shown in the guide, one mysql is for website/forum/teamspeak/etc (app serv 2.5.10) and the other is mysql 5.1 (this is for the eq server). i used -this guide- to run this server and followed it as closely as i could. Yes I can connect via navicat and even into the game and others can connect to my server in-game too. |
http://dev.mysql.com/doc/refman/5.1/en/grant.html
You spelled PRIVILEGES wrong. Easier to just say "GRANT ALL ON *.* TO 'someuser'@'somehost';" Of course, root should already have them. |
All times are GMT -4. The time now is 03:58 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.