Okay, I got some tables I am going to have accessible that I want to have multiple users have full access or just read access to. I have fallen into a portable hole. How do I create users and allow them to access the system?
Here, I have already done this command
But when I try to login you see what I get. Any ideas? I wanted to use MySQL GUI to start filling up some tables. MySQL GUI wont connect either. Even if I try to use login root. I figure maybe you guys have a clue as to where I am screwing up.
[schotty@leinenkugel apt]$ mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all on * to schotty identified by 'password';
Query OK, 0 rows affected (0.01 sec)
[schotty@leinenkugel apt]$ mysql -p
ERROR 1045: Access denied for user: 'schotty@localhost' (Using password: YES)