Results 1 to 3 of 3

Thread: Why is a backslash added to Db field of db table of the mysql database of MySQL?

  1. #1
    Registered Member
    Join Date
    Dec 2004
    Posts
    52

    Unhappy Why is a backslash added to Db field of db table of the mysql database of MySQL?

    Hi, all.

    I have encountered the strange problem in MySQL.
    In the "MySQL-Databases" screen of Cpanel, even if it changes "Grant permissions on a MySQL database to a MySQL user", I have become with "Privileges: ALL PRIVILEGES".

    So, it shows that Privileges is not changed.

    When the log of MySQL is recorded, it looks like a cause that a backslash is added to the underbar (_) of a database name (Db), and the query is run.

    How should I Fix this problem?

    The following is record of the query at the time of changing "Grant permissions on a MySQL database to a MySQL user".

    [MySQL Log]========================================================
    5 Connect root_user@localhost on mysql
    5 Query SET AUTOCOMMIT=1
    5 Query FLUSH PRIVILEGES
    5 Query show databases
    5 Query select Host from user where User REGEXP "^username\_"
    5 Query select Host from user where User='username'
    5 Query replace into user (host,user,password) values('localhost','username',password('password'))
    5 Query GRANT ALL ON `dbusername\_dbname`.* TO 'username'@localhost
    5 Query FLUSH PRIVILEGES
    5 Quit
    6 Connect root_user@localhost on mysql
    6 Query SET AUTOCOMMIT=1
    6 Query select Host from user where User REGEXP "^username\_"
    6 Query select Host from user where User='username'
    6 Query FLUSH PRIVILEGES
    6 Query GRANT CREATE,DELETE,SELECT,INSERT,UPDATE ON `username\_dbname`.* TO 'username_dbusername'@'localhost'
    6 Query FLUSH PRIVILEGES
    6 Query show databases
    6 Query select Host from user where User REGEXP "^username\_"
    6 Query select Host from user where User='username'
    6 Query replace into user (host,user,password) values('localhost','username',password('password'))
    6 Query GRANT ALL ON `username\_dbname`.* TO 'username'@localhost
    6 Query FLUSH PRIVILEGES
    6 Quit

    ========================================================

    [select * from db;]========================================================

    +-----------+----------------+----------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
    | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
    +-----------+----------------+----------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
    | localhost | username_dbname | username | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | <--- 1
    | localhost | username\_dbname | username | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | <--- 2
    | localhost | username_dbname | username_dbusername | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | <--- 3
    | localhost | username\_dbname | username_dbusername | Y | Y | Y | Y | N | N | N | N | N | N | N | N | <--- 4
    ========================================================
    Last edited by PondRicefied; 09-15-2005 at 10:10 PM.
    WHM 11.32.X
    RHEL5.X

  2. #2
    Registered Member
    Join Date
    Dec 2004
    Posts
    52

    Default

    Everyone?

    Can everyone do change of Priviledge in a control panel?
    Can't only I do it?

    Please give me advice if you please.
    Please please please help.
    Last edited by PondRicefied; 09-14-2005 at 07:02 AM.
    WHM 11.32.X
    RHEL5.X

  3. #3
    Registered Member
    Join Date
    Dec 2004
    Posts
    52

    Angry

    The issue of Cpanel? or MySQL? or php?

    If direct GRANT is run by the shell on SSH, I have no problem, but when it changes from Cpanel, I happen.

    Pleeeeeeeeeeeeeeeeese heeeeeeeeeeeeeeeeeeeeeeelp.
    WHM 11.32.X
    RHEL5.X

Similar Threads

  1. How to set correct field in my table for date?
    By toplisek in forum Database Discussions
    Replies: 3
    Last Post: 02-04-2011, 03:05 PM
  2. Replies: 0
    Last Post: 01-17-2011, 12:42 PM
  3. Couple times mysql lost user added to database, HELP.
    By hekri in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 06-20-2006, 11:06 AM
  4. CPanel Changing MYSQL table field properties
    By it-lighthouse in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 02-22-2005, 02:12 PM
  5. cPanel adds backslash in mysql db table?
    By dindesign in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 10-26-2004, 01:56 PM
bargain