Search:

a) if you are trying to create a user, you should use the create user syntax rather than inserting into any user tables b) If the user table is a table you wish to create, then Create and Select a...

Yes. You should not allow all users full access to your database. You may also need sudo access to start/stop, which could be one of your issues. Try running the following to start:
sudo mysqld_safe...

Yes. Use the terminal



Did you ever set the password for root? If not, remove the -p. If yes, verify you are entering the correct password. Or, change/set your password via mysqladmin

The error is just one reason to read post #2 again. Moving strait into JDBC can cause more problems along the way - understanding how to use the database via command line interface helps to decouple...

Get familiar with the database. Use the command line to connect to the database, create users, create tables, and learn about database normalization, keys, indexes, and referential integrity...