root@ubuntu1204-BpOyGFi2g7WO:~# mysql -proot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 54 Server version: 5.5.31-0ubuntu0.12.04.2-log (Ubuntu) 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. mysql> CHECK TABLE mysql.user; +------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------+-------+----------+----------+ | mysql.user | check | status | OK | +------------+-------+----------+----------+ 1 row in set (0.00 sec) mysql> SELECT User, Host, Password FROM mysql.user; +------------------+-------------------------+-------------------------------------------+ | User | Host | Password | +------------------+-------------------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ubuntu1204-BpOyGFi2g7WO | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ::1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-BpOyGFi2g7WO | | | debian-sys-maint | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | repl | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | +------------------+-------------------------+-------------------------------------------+ 8 rows in set (0.00 sec) mysql> DROP USER ''@'ushastry'; ERROR 1396 (HY000): Operation DROP USER failed for ''@'ushastry' mysql> DROP USER ''@'ubuntu1204-BpOyGFi2g7WO'; ERROR 1396 (HY000): Operation DROP USER failed for ''@'ubuntu1204-bpoygfi2g7wo' mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> DROP USER ''@'ubuntu1204-BpOyGFi2g7WO'; Query OK, 0 rows affected (0.00 sec) mysql> SELECT User, Host, Password FROM mysql.user; +------------------+-------------------------+-------------------------------------------+ | User | Host | Password | +------------------+-------------------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ubuntu1204-BpOyGFi2g7WO | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ::1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-BpOyGFi2g7WO | | | debian-sys-maint | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | repl | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | +------------------+-------------------------+-------------------------------------------+ 8 rows in set (0.00 sec) mysql> GRANT ALL ON *.* TO ''@'ubuntu1204-BpOyGFi2g7WO'; Query OK, 0 rows affected (0.00 sec) mysql> SELECT User, Host, Password FROM mysql.user; +------------------+-------------------------+-------------------------------------------+ | User | Host | Password | +------------------+-------------------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ubuntu1204-BpOyGFi2g7WO | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ::1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-BpOyGFi2g7WO | | | debian-sys-maint | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | repl | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-bpoygfi2g7wo | | +------------------+-------------------------+-------------------------------------------+ 9 rows in set (0.00 sec) mysql> DROP USER ''@'ubuntu1204-BpOyGFi2g7WO'; Query OK, 0 rows affected (0.00 sec) mysql> SELECT User, Host, Password FROM mysql.user; +------------------+-------------------------+-------------------------------------------+ | User | Host | Password | +------------------+-------------------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ubuntu1204-BpOyGFi2g7WO | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ::1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-BpOyGFi2g7WO | | | debian-sys-maint | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | repl | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | +------------------+-------------------------+-------------------------------------------+ 8 rows in set (0.00 sec) mysql> Bye root@ubuntu1204-BpOyGFi2g7WO:~# mysql_upgrade -proot --force Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Running 'mysql_fix_privilege_tables'... OK root@ubuntu1204-BpOyGFi2g7WO:~# mysql -proot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 60 Server version: 5.5.31-0ubuntu0.12.04.2-log (Ubuntu) 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. mysql> SELECT User, Host, Password FROM mysql.user; +------------------+-------------------------+-------------------------------------------+ | User | Host | Password | +------------------+-------------------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ubuntu1204-BpOyGFi2g7WO | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ::1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-BpOyGFi2g7WO | | | debian-sys-maint | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | repl | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | +------------------+-------------------------+-------------------------------------------+ 8 rows in set (0.00 sec) mysql> DROP USER ''@'ubuntu1204-BpOyGFi2g7WO'; Query OK, 0 rows affected (0.00 sec) mysql> SELECT User, Host, Password FROM mysql.user; +------------------+-------------------------+-------------------------------------------+ | User | Host | Password | +------------------+-------------------------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ubuntu1204-BpOyGFi2g7WO | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | ::1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | | ubuntu1204-BpOyGFi2g7WO | | | debian-sys-maint | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | repl | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | +------------------+-------------------------+-------------------------------------------+ 8 rows in set (0.00 sec) mysql> SHOW GLOBAL VARIABLES LIKE '%init_file%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | init_file | | +---------------+-------+ 1 row in set (0.00 sec) mysql> Bye root@ubuntu1204-BpOyGFi2g7WO:~# dpkg -l | grep mysql ii libdbd-mysql-perl 4.020-1build2 Perl5 database interface to the MySQL database ii libmysqlclient-dev 5.5.31-0ubuntu0.12.04.2 MySQL database development files ii libmysqlclient18 5.5.31-0ubuntu0.12.04.2 MySQL database client library ii mysql-client 5.5.31-0ubuntu0.12.04.2 MySQL database client (metapackage depending on the latest version) ii mysql-client-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database client binaries ii mysql-client-core-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database core client binaries ii mysql-common 5.5.31-0ubuntu0.12.04.2 MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.5.31-0ubuntu0.12.04.2 MySQL database server (metapackage depending on the latest version) ii mysql-server-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database server binaries and system database setup ii mysql-server-core-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database server binaries ii python-mysqldb 1.2.3-1ubuntu0.1 Python interface to MySQL