MySQL DBs d'on't work

[Thafusion]

when i create them as a user and try to test them @ http://217.67.239.90/phpMyAdmin/ it just don't work also i tested it on some script like phpbb2 that couln't connected to the database
MySQL Process is running


Greetz Roel

[ProWebUK]

any errors?

[Thafusion]

nope no errors
with making the database
and status is active

[ProWebUK]

can you login to phpmyadmin?

[Thafusion]

i made a admin
with the admin a reseller
and then a user called
login test1 ,pass testtest

then i made a database



Database Created
Details
Your database has been setup. Use the following values:
Database: test1_data
Host: localhost
Username: test1_test
Password: testdatabase


then i wanted to log on with ip/phpMyAdmin/

i typed
test1_test
testdatabase

didn't work
also test1 testtest
test1_data testdatabase

everything dodn't work :(

[ProWebUK]

https://IP/phpMyAdmin/

username: da_admin
password: **your FIRST DA password for admin**

also, do any other mysql users work... ?

[Thafusion]

i also tested it with making other users.

[DirectAdmin Support]

Hello,

You probably have a mysql.sock file located somewhere where DA knows to find it, but nothing else does. If you have one, check your /etc/my.cnf file to see the location of the mysql.sock file. DirectAdmin looks in /var/lib/mysql/mysql.sock for it, but phpMyAdmin might be looking in /tmp/mysql.sock.

Easy fix:
If /var/lib/mysql/mysql.sock exists, create a symbolic link to it from /tmp/mysql.sock
cd /tmp
ln -s /var/lib/mysql/mysql.sock .

John

[Thafusion]

yup it works now
great :)

[Sentinel]

I had the same problem. I did what you said up top, and yeah, sure, I can log in now. BUT, the only thing it shows me now are the frames but no page... ??

-The Sentinel

[DirectAdmin Support]

Hello,

There is a weird php bug for some people with output buffering. By turning it off, it should work. Just paste the following into your command line as root:

/usr/bin/perl -pi -e 's/\$mode = 1;/\$mode = 0;/' /var/www/html/phpMyAdmin-2.5.0/libraries/ob.lib.php

John

[Sentinel]

Thank you, it is working now! :)

-The Sentinel