Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th December 2008, 14:04
blocker blocker is offline
Senior Member
 
Join Date: Mar 2008
Posts: 177
Thanks: 9
Thanked 4 Times in 4 Posts
Question mysql user names and databse names problem

Hello,

i have the following problem:

i have a web page - web57 with databases web57_db1 with user web57_u1 and web57_db2 with user web57_u2.

the problem is when i login to phpmyadmin with user web57_u1, i see all the databases web57*_db1 - for example web577_db1, web578_db1 e.t.c.

and

when i login to phpmyadmin with user web57_u2 i see all the databases web57*_db2 - for example web577_db2, web578_db2 e.t.c.

what could be the reason for that, and how can i fix that without changing database names and database users...

Thanks!
Reply With Quote
Sponsored Links
  #2  
Old 15th December 2008, 17:49
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,169
Thanks: 829
Thanked 5,412 Times in 4,255 Posts
Default

Thats a known bug in mysql and related to the underscore in the usernames which is misinerpreted by mysql as wildcard. All current ispconfig versions use a new naming scheme to prevent this for newly created databases.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th December 2008, 17:55
blocker blocker is offline
Senior Member
 
Join Date: Mar 2008
Posts: 177
Thanks: 9
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by till View Post
Thats a known bug in mysql and related to the underscore in the usernames which is misinerpreted by mysql as wildcard. All current ispconfig versions use a new naming scheme to prevent this for newly created databases.
Thanks for the reply

i would like to ask if there is another solution to go over the problem except renaming the databases and the user names?

Thanks!
Reply With Quote
  #4  
Old 15th December 2008, 18:01
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,169
Thanks: 829
Thanked 5,412 Times in 4,255 Posts
Default

There is no other solution as far as I know. But maybe you find something with google, the problem with underscores in mysql usernames is not ispconfig specific.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 15th December 2008, 18:14
blocker blocker is offline
Senior Member
 
Join Date: Mar 2008
Posts: 177
Thanks: 9
Thanked 4 Times in 4 Posts
 
Default

i just asked, it became clear that it is not ispconfig related just after your 1st post

thanks a lot
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql Databse Name adm-computers Installation/Configuration 1 23rd January 2007 10:03


All times are GMT +2. The time now is 11:53.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.