IT/Software/Database Applications/mysql command line/mysql commands
Access restrictions were established for this page. If you see this message, you have no access to this page.
Here we will list helpful things to do on mysql
when we say mysql that means you are on a server and are running mysql
- From the command line type mysql -u root
- Enter your password
- It will not appear
- Now you are in mysql!
Deleting data older than a date
- Get into mysql as a root or otherwise privileged user
- You can also login in as the user to the database you want to work on.
- But if that use has global or high privileges you stand the cnace of breaking something
- Don't be fooled by the above statement. You ALWAYS stand the chance of breaking something.
- Select the database you want
use databasetoworkon
Restoring root access
- For some reason root access by password was removed from the defaults at some point
- I first noticed this on Ubuntu Server 18.04
- There are many and varied ways to restore this.
- Beware not all of them work.
- The below one was derived from a Tutorial on Digital Ocean
- Thanks guys!