Curious Too

Well-Known Member
Aug 31, 2001
432
1
318
cPanel Access Level
Root Administrator
phpmyadmin that's bundled with cPanel will show users only the databases they own. However, phpmyadmin installed as a stand alone application will show users all databases on the server. Is anyone else experiencing this problem?
 

jackal

Well-Known Member
PartnerNOC
Feb 23, 2002
707
0
316
We are running edge, and after the update we were taken from 4.0.24 to version 4.0.25 when this happened we had the same issue. We resolved it by restarting mysql.

Joey
 

Curious Too

Well-Known Member
Aug 31, 2001
432
1
318
cPanel Access Level
Root Administrator
jackal said:
We are running edge, and after the update we were taken from 4.0.24 to version 4.0.25 when this happened we had the same issue. We resolved it by restarting mysql.

Joey
I restarted mysql but I can still see all the databases. Not in cPanel's phpmyadmin, but in a version of phpmyadmin that I installed separately (2.6.3-pl1).
 

linux-image

Well-Known Member
Jun 8, 2004
1,190
1
168
India
cPanel Access Level
Root Administrator
since the default one is working, it shouldnt be a problem with the database permissions. just t be safe, you can run /scripts/cleanupmysqlprivs

if this doesnt help, it must be a problem with the configuration of the new phpadmin. try copying the default config file that is working to the new one.
 

Curious Too

Well-Known Member
Aug 31, 2001
432
1
318
cPanel Access Level
Root Administrator
linux-image said:
since the default one is working, it shouldnt be a problem with the database permissions. just t be safe, you can run /scripts/cleanupmysqlprivs

if this doesnt help, it must be a problem with the configuration of the new phpadmin. try copying the default config file that is working to the new one.

Thanks, /scripts/cleanupmysqlprivs fixed the problem. Unfortunately I have to run it on 30 servers.
 

q8ss

Member
Nov 2, 2004
5
0
151
Dear sir,
i had the same problem and when i run this command /scripts/cleanupmysqlprivs
it gave me this erorr


Code:
Cleaning up mysql privs.  Please ignore errors about non-existant columns as you may have an older version of mysql.....--------------
update user set Create_priv='N' where Create_priv='Y' and User != 'root'
--------------

--------------
update user set Create_tmp_table_priv='N' where Create_tmp_table_priv='Y' and User != 'root'
--------------

ERROR 1054 at line 2: Unknown column 'Create_tmp_table_priv' in 'where clause'
--------------
update user set Lock_tables_priv='N' where Lock_tables_priv='Y' and User != 'root'
--------------

ERROR 1054 at line 3: Unknown column 'Lock_tables_priv' in 'where clause'
--------------
update user set Execute_priv='N' where Execute_priv='Y' and User != 'root'
--------------

ERROR 1054 at line 4: Unknown column 'Execute_priv' in 'where clause'
Done.
 

q8ss

Member
Nov 2, 2004
5
0
151
this is the user table in mysql


Code:
mysql> DESCRIBE user ;
+-----------------+-----------------+------+-----+---------+-------+
| Field           | Type            | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| Host            | char(60) binary |      | PRI |         |       |
| User            | char(16) binary |      | PRI |         |       |
| Password        | char(16) binary |      |     |         |       |
| Select_priv     | enum('N','Y')   |      |     | N       |       |
| Insert_priv     | enum('N','Y')   |      |     | N       |       |
| Update_priv     | enum('N','Y')   |      |     | N       |       |
| Delete_priv     | enum('N','Y')   |      |     | N       |       |
| Create_priv     | enum('N','Y')   |      |     | N       |       |
| Drop_priv       | enum('N','Y')   |      |     | N       |       |
| Reload_priv     | enum('N','Y')   |      |     | N       |       |
| Shutdown_priv   | enum('N','Y')   |      |     | N       |       |
| Process_priv    | enum('N','Y')   |      |     | N       |       |
| File_priv       | enum('N','Y')   |      |     | N       |       |
| Grant_priv      | enum('N','Y')   |      |     | N       |       |
| References_priv | enum('N','Y')   |      |     | N       |       |
| Index_priv      | enum('N','Y')   |      |     | N       |       |
| Alter_priv      | enum('N','Y')   |      |     | N       |       |
+-----------------+-----------------+------+-----+---------+-------+
17 rows in set (0.00 sec)

actually any user can't access other Database ,, but what i need is dont showing ALL databases name
 
Last edited:

linux-image

Well-Known Member
Jun 8, 2004
1,190
1
168
India
cPanel Access Level
Root Administrator
Please ignore errors about non-existant columns as you may have an older version of mysql.....

this is already been told by the script. so u can stop worying about the column errors
 

Cristian99

Active Member
Jun 17, 2005
38
0
156
I can view all db only with some browser
With IE 6.x i don't see all db
woth mozilla i see al db
:confused: