Administrators, Swags, Bureaucrats, Administrators
3,838
edits
MySQL Server Install on Ubuntu Server: Difference between revisions
MySQL Server Install on Ubuntu Server (view source)
Revision as of 21:10, 15 November 2024
, 15 November 2024no edit summary
No edit summary |
No edit summary |
||
| Line 21: | Line 21: | ||
Create a new user, where 'password' is your password | Create a new user, where 'password' is your password | ||
CREATE USER 'joey'@'localhost' IDENTIFIED BY 'password'; | CREATE USER 'joey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; | ||
Output should look like <code>Query OK, 0 rows affected (0.01 sec)</code> | Output should look like <code>Query OK, 0 rows affected (0.01 sec)</code> | ||
| Line 27: | Line 27: | ||
Edit the password if needed later | Edit the password if needed later | ||
ALTER USER 'joey'@'localhost' IDENTIFIED | ALTER USER 'joey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password'; | ||
Next, grant privileges as needed (this example grants ALL privileges so use sparingly) | Next, grant privileges as needed (this example grants ALL privileges so use sparingly) | ||