sql problems

J

jep

Verified User
Joined
Nov 12, 2003
Messages
79
Hi,

I just installed my first directadmin: great! I already love it (way more then i did with plesk)

One problem. When logged in as a user/admin/whatever i want to manage sql databases but I see the error:

Code: 
Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES)

I think there's a wrong password in mysql.conf because i installed directadmin 4 times :p :p

How can i reset/change the password for this database?

Another thing: when i click phpmyadmin on the same page, i see a 404 error.. This is just http://hostnamefromserver/phpMyAdmin

Any clue? Thanks guys!
 
Try http://IP/phpMyAdmin instaed of hostname, you may need to add an A record for the hostname against the main server IP for the hostname to work, although if that was the case you shouldnt get a 404, instaed there should be a cannot 'cannot find server' error.

Chris
 
Hello,

If you've installed DA 4 times, then something is bound to have gotten messed up.. :) Try this:

cd /usr/local/directadmin/scripts
./mysql.sh <mysqlrootpass> da_admin <da_adminpass>

You can make up whatever passwords you want for <mysqlrootpass> and <da_adminpass> as they'll be used during the install. Be sure to select "y" when it asks to destroy your current data so that it will delete /var/lib/mysql. This allows a clean install for it to be able to login as root, create the required users and setup the passwords.

John
 
Hi,

The SQL-password problem is solved, thanks for what.

The phpmyadmin still doesn't work, i get a 404 when i use http://hostname/phpMyAdmin by using DA, and the same by using the ip instead of the hostname.

Anybody some clue? :)

Yes I made some databases..
 
weird.

try https:// although I cant see it working unless something has been modified, its possible... if that fails, if you wish PM, me your IP and i will try a couple of URLs
 
Ok just checked the link you provided me with, and the message above. I think the quickest and easiest solution would be to rename the folder (i think that may be causing the problem)

locate phpMyAdmin-2.5.4

(get the path)

mv /path/to/phpMyAdmin-2.5.4/ /path/to/phpMyAdmin/

Chris
 
Last edited:
Ok, but then again.. i still can't use Phpmyadmin in DA. I have to finish this config for a dedicated server client, he will like it if it works :p:p

Thanks..
 
jep said:
Ok, but then again.. i still can't use Phpmyadmin in DA. I have to finish this config for a dedicated server client, he will like it if it works :p:p

Thanks..
Click to expand...

this has done more than confuse me :p

Did you move the phpMyAdmin folder as stated in my other post?

It looks like the phpMyAdmin installation went into a wrong loation, and thats the fix...... if you chnage that directory you should be able to access it via http://IP/phpMyAdmin AND http://domain.com/phpMyAdmin.... and im assuming DA has nothing to do with MyAdmin apart from the link to it.

Chris
 
But, that means that i have to move phpMyAdmin to every public_html folder? :p I supposed that it was a link to a central phpmyadmin somewhere?
 
nooo...... the /phpmyadmin i believe is a link..... if you rename the folder to phpMyAdmin that will be your central phpMyAdmin used by domain.com/phpMyAdmin.

If it fails you can always rename the file back with the same command with the paths swapped around.... im 99.9% certain DA uses MySQL itself to setup databases etc.... phpmyadmin is just the user interface and totally seperate.


Chris
 
ProWebUK said:
Have you tried the rename? if not i will put my money on saying that it works. Just try it! you have nothing to loose!
Click to expand...

How much money? :p
http://www.domain.nl/phpMyAdmin-2.5.4/ is not setup by DA to be a redirect, http://www.domain.nl/phpMyAdmin/, however is.

Chris
Click to expand...
True, but now i'm not talking about the link in DA, but just accesing it from somewhere. After my rename it's reachable on http://ip.adr.es.here/phpMyAdmin, but still not on http://www.hostnameinDA.com/phpMyAdmin, so the phpMyAdmin link is still a 404 error.
 
http://hostname.com/phpMyAdmin/ (if your hostname has an A record)
http://YOUR_IP/phpMyAdmin/
http://domain_in_da.com/phpMyAdmin/

should all work, however, if your central phpmyadmin is NOT /phpMyAdmin, but instead phpMyAdmin-2.5.4, the first 2:

http://hostname.com/phpMyAdmin-2.5.4/ (if your hostname has an A record)
http://YOUR_IP/phpMyAdmin-2.5.4/


will both work;

http://domain_in_da.com/phpMyAdmin-2.5.4/

However, will not.

If you are worried about renaming the folder, make a copy and leave your previous version there, instaed of 'mv' in my post use 'cp'

Im certain that will work and fix all of your sql problems.

Chris
 
Did you try the moving / copying files? if so did it work?

Chris
 
You must log in or register to reply here.
Back
Top