Table mysql user doesn t exist ERROR

Question

I am creating a db in mysql for a java program My program works well in my friends system But I have some problem with my mysql   The query is below   mysql gt  create database sampledb   Query OK  1 row affected  0 00 sec   mysql gt  use sampledb   Database changed  mysql gt  create user zebronics identified by  zebra123    ERROR 1146  42S02   Table  mysql user  doesn t exist   I cant create any user for my db Please help

User · Answer

Error Code  1046      This error shows that the table does not exist may sometimes be caused by having selected a different database and running a query referring to another table  The results indicates       No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar   Will solve the issue and it worked for me very well

User · Answer

Same issue here as lxxxvi describes  Running       mysql upgrade -u root   allowed me to then successfully enter a password that      mysql secure installation   was waiting for

User · Answer

You can run the following query to check for the existance of the user table   SELECT   FROM information schema TABLES WHERE TABLE NAME LIKE   user     See if you can find a row with the following values in  mysql   user    BASE TABLE  MyISAM     If you cant find this table look at the following link to rebuild the database How to recover recreate mysql  39 s default   39 mysql  39  database

User · Answer

Try run mysqladmin reload  which is located in  usr loca mysql bin  on mac

User · Answer

My solution was to run   mysql upgrade -u root   Scenario  I updated the MySQL version on my Mac with  homebrew upgrade   Afterwards  some stuff worked  but other commands raised the error described in the question

User · Answer

Your database may be corrupt  Try to check if mysql user exists   use mysql  select   from user    If these are missing you can try recreating the tables by using  mysql install db  or you may have to clean  completely remove it  and reinstall MySQL

User · Answer

Looks like something is messed up with your MySQL installation  The mysql user table should definitely exist  Try running the command below on your server to create the tables in the database called mysql   mysql install db   If that doesn t work  maybe the permissions on your MySQL data directory are messed up  Look at a  known good  installation as a reference for what the permissions should be   You could also try re-installing MySQL completely

User · Answer

show databases   --------------------    Database              --------------------    information schema     datapass schema        mysql                  test                  --------------------  4 rows in set  0 05 sec   mysql gt  use mysql  Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A  Database changed mysql gt  show tables     - gt     ---------------------------    Tables in mysql              ---------------------------    columns priv                  db                            event                         func                          general log                   help category                 help keyword                  help relation                 help topic                    host                          ndb binlog index              plugin                        proc                          procs priv                    servers                       slow log                      tables priv                   time zone                     time zone leap second         time zone name                time zone transition          time zone transition type     user                         ---------------------------  23 rows in set  0 00 sec   mysql gt  create user m identified by  m   Query OK  0 rows affected  0 02 sec    check for the database mysql and table user as shown above if that dosent work  your mysql installation is not proper   use the below command as mention in other post to install tables again   mysql install db

[mysql] Table 'mysql.user' doesn't exist:ERROR

Examples related to mysql