phpMyAdmin Config

[jasonlamkk]

after installing DA (a clean install),

i find that phpMyAdmin was not linked up with directAdmin,
no-one can login by DA username and password, but only MySQL accounts that i created, da_admin also.

i think this is a problem of phpMyAdmin config.inc.php

$cfg['PmaAbsoluteUri'] = '';


$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

i don't think the auth_type should be http which ask user to input a MySQL account instead of using DA account,
but what config may allow DA to auth the user?
(i found out 2 config.inc.php files,
- one in /var/www/html/phpMyAdmin*/
- one in /usr/local/directadmin/(forget)/
this one is protected (owner= root, mod 711)
but both have the same content, ie use http auth
i tried to use 'config' auth with da_admin and password, then all user can view all database (since they are using the same phpMyAdmin folder with configured account and password)

shall i make a copy of phpMyAdmin to http://domain.com:2222/phpMyAdmin/
? (this may block access from public but all users may view database of eachother)

i have saw sb. posted his config.inc.php with a complex $cfg['PmaAbsoluteUri'] , but the one on my machine is the same as the one downloaded from phpMyAdmin.net, so where can i find the one provided by DA?

 

[jasonlamkk]

about DA's struture?

my server rental provider changed some setting and let DA to create a mysql_user for each account created, and change its privilege whenever a new database is created by him, so that he can access phpMyAdmin by his user name and password,
but how to create such a script?

------------------------
i am going to upgrade mysql from 4.0 to 4.1 to use sub-query and utf-8 tables,
after upgrade they would not do such support anymore, so may anyone tell me where's this script located.
------------------------

 

[sky]

hello

I have the same problem, i cant find how to solv it...

Sky

 

[jasonlamkk]

Hi sky,

my supporting company seems to solved it by setting a script to set database permission for that reseller
ie
'user1' create database "mysqltest"

add all premission on "mysqltest" for 'user1' just after it was created

don't know why this part have problem using standard installation?
may sb. from directadmin.com tell us more detail?

 

[sky]

hello

just to say that the DA users cant accecc phpmyadmin.

but the mysql database they create are ok. i mean i can access phpmyadmin with user_database / password.

I just cant get this pb...

 

[jasonlamkk]

details

if
users named "example" own domain "example.com", has password 'abcd'

and create databases as follow:

example_test1, password 1234
example_test2, password 5678

he (or anything on localhost) can access the databases by mysql_connect('localhost','example_test1','1234') and
mysql_connect('localhost','example_test2','5678')

but usually user want to use a single auth to manage all database belong to him,
if DA also add a mysql user named "example" with PASSWORD('abcd')and grant access right to him, then he can use his DA password to access both db.

** i think mysql and DA both have their own auth. system, so what can be done is duplicate the users to mysql
or may be other settings to link up the auth-session of DA with phpmyadmin so do not require a second log-in?

once-upon-a-time, i remeber i was able to enter phpmyadmin by a single click, but i cannot find any related posts to make that again, so i just accept the current method.

 

[jamin1317]

Manage all user mysql databases

It's been my experience:

When DA creates the 1st database for a user it creates the main sql username and password at that time. It uses the control panel account name for the username and the password of the first database.

Example:

Account name test

create db first
password 1234

becomes test_first

create db second
password 5678

becomes test_second

The phpMyAdmin username would be test (same as control panel)
the phpMyadmin password would be 1234 (same as first database)

log into phpMyAdmin with username test password 1234 and you will have access to all the databases of this user.

Login to phpMyAdmin with username test_first and you will only have access to that database.

 

[jasonlamkk]

Re: Manage all user mysql databases

It's been my experience:

When DA creates the 1st database for a user it creates the main sql username and password at that time. It uses the control panel account name for the username and the password of the first database.

Example:

Account name test

create db first
password 1234

becomes test_first

create db second
password 5678

becomes test_second

The phpMyAdmin username would be test (same as control panel)
the phpMyadmin password would be 1234 (same as first database)

log into phpMyAdmin with username test password 1234 and you will have access to all the databases of this user.

Login to phpMyAdmin with username test_first and you will only have access to that database.

it 's quite strange (to users experience at least) if it use the first databases password,
anyway, i think the code reponsible to creating database shall be in Scripting languages not binary code, otherwise my supporting company would not be able to change fix it.
(i guess its written in php)