The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
Losing one can be a difficult issue to encounter. Luckily, resetting the root password is easy as long as you have sudo access to the Server.
Not the Server root user
A common issue is confusing the Server root user with the MySQL root user. Continue reading “Reset a lost MySQL root password”
How do I delete a file under Linux / UNIX / BSD / AIX / HP-UX operating system using command line options?
To remove a file or directory in Linux, FreeBSD, Solaris or Unix-like operating systems use the rm command or unlink command.
Continue reading “linux delete or remove file”
Since AWS is entirely self-managed, it’s up to you to keep your instance updated and secure. That’s a lot of responsibility, so I recommend setting up a calendar alert on your phone and/or computer so that you go through the motions at least once a month.
Backups in AWS are surprisingly simple. To create a backup, you simply make a “Snapshot” of your instance.
1) Log into your AWS Console
2) Go to your EC2 dashboard
3) Go to your Volumes tab.
Continue reading “AWS Backups”
How do I show/list the tables in a MySQL database (using the mysql command line client)?
To list/show the tables in a MySQL database:
Log into your database using the MySQL client, Issue the use command to connect to your desired database, and then Use the MySQL show tables command.
Continue reading “List tables in a MySQL database”
First You have to change the file as root user.
sudo nano /etc/httpd/conf/httpd.conf
Make your changes and save with ctrl + O, Enter. to save.