| Bug #69365 | user root% | ||
|---|---|---|---|
| Submitted: | 31 May 2013 14:20 | Modified: | 4 Jun 2013 10:24 |
| Reporter: | Myriam BEAUMIER | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
| Version: | 5.6.11 | OS: | Linux (debian v7) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | acces denied for user root % | ||
[31 May 2013 14:20]
Myriam BEAUMIER
[31 May 2013 15:07]
MySQL Verification Team
Thank you for the bug report. What happens if you try to connect without a password? mysql -uroot Thanks.
[3 Jun 2013 7:43]
Myriam BEAUMIER
mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.6.11-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@dba-test:3312[(none)]> exit it works but it's not any secure? skip-grant-tables exits in my.cnf but it's a problem to create user and grant user,drop user ... because I've error : drop user demo; ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement Can you help me please? thanks
[3 Jun 2013 13:12]
Myriam BEAUMIER
can you help me about this issue please? I've another problem: Icreated a new user : Create user 'iritrack'@'%' identified by 'astri_um'; Query OK, 0 rows affected (0.00 sec) root@dba-test:3314[(none)]> grant select, insert, update, execute, delete on *.* to 'demo'@'%'; Query OK, 0 rows affected (0.00 sec) root@dba-test:3314[(none)]> flush privileges; Query OK, 0 rows affected (0.00 sec) root@dba-test:3314[(none)]> exit Bye dba-test(db-satcom-p):/mysql/config $ mysql -uiritrack -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.6.11-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. iritrack@dba-test:3314[(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ 1 row in set (0.00 sec) iritrack@dba-test:3314[(none)]> exit Bye dba-test(db-satcom-p):/mysql/config $ ls -rtl total 16 lrwxrwxrwx 1 mysql mysql 43 May 28 15:52 mysql.db-dsc-p.cnf -> /mysql/sgbd/db-dsc-p/var/mysql.db-dsc-p.cnf lrwxrwxrwx 1 mysql mysql 58 May 29 14:40 mysql.db-satcomms-dev.cnf -> /mysql//sgbd/db-satcomms-dev/var/mysql.db-satcomms-dev.cnf -rwxr-xr-x 1 mysql mysql 893 May 30 12:31 StartStop_db-dsc-p.bsh lrwxrwxrwx 1 mysql mysql 49 May 30 12:52 mysql.db-satcom-p.cnf -> /mysql/sgbd/db-satcom-p/var/mysql.db-satcom-p.cnf -rwxr-xr-x 1 mysql mysql 899 May 30 12:53 StartStop_db-satcom-p.bsh srwxrwxrwx 1 mysql mysql 0 May 30 13:40 mysql.db-dsc-p.sock lrwxrwxrwx 1 mysql mysql 45 May 31 10:30 mysql.db-demo-p.cnf -> /mysql/sgbd/db-demo-p/var/mysql.db-demo-p.cnf -rwxr-xr-x 1 mysql mysql 895 May 31 14:56 StartStop_db-demo-p.bsh srwxrwxrwx 1 mysql mysql 0 Jun 3 11:01 mysql.db-demo-p.sock lrwxrwxrwx 1 mysql mysql 43 Jun 3 14:16 mysql.db-edf-p.cnf -> /mysql/sgbd/db-edf-p/var/mysql.db-edf-p.cnf -rwxr-xr-x 1 mysql mysql 893 Jun 3 14:19 StartStop_db-edf-p.bsh srwxrwxrwx 1 mysql mysql 0 Jun 3 14:58 mysql.db-edf-p.sock srwxrwxrwx 1 mysql mysql 0 Jun 3 15:02 mysql.db-satcom-p.sock dba-test(db-satcom-p):/mysql/config $ ./StartStop_db-satcom-p.bsh stop [ ok ing down MySQL... dba-test(db-satcom-p):/mysql/config $ ./StartStop_db-satcom-p.bsh start [ ok ing MySQL.. dba-test(db-satcom-p):/mysql/config $ mysql -uiritrack -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.11-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. iritrack@dba-test:3314[(none)]> show databases; +--------------------+ I exit and after to stop and start instance mysql to see with the same user show databases , it's normal? dba-test(db-satcom-p):/mysql/config $ ./StartStop_db-satcom-p.bsh stop [ ok ing down MySQL... dba-test(db-satcom-p):/mysql/config $ ./StartStop_db-satcom-p.bsh start [ ok ing MySQL.. dba-test(db-satcom-p):/mysql/config $ mysql -uiritrack -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.11-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. iritrack@dba-test:3314[(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ 3 rows in set (0.00 sec) I'm waiting for you response please?
[4 Jun 2013 10:24]
MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL. I see no evidence of any bug in the product. If you have skip-grant-tables then you need to first FLUSH PRIVILEGES to be able to create users, set passwords, grant privileges.
