Access your MySQL database for maintenance without a password
MySQL is perhaps one of the most popular database systems currently available. It has a lot of great features, it's open source, and a lot of Web-based applications use it for their back-end storage.
One important part of running a database is maintenance, and that includes backups. However, due to the fact that the database is password-protected, one can't automatically back up the database without interactively supplying the password. And, depending on what you need to back up, you may even have to use the MySQL "root" user to do a full backup.
You can avoid those hassles by creating a configuration file for the user to do the backups (i.e., /root/.my.cnf). This user does not need to be the system root user; it can be any normal system user who has access to the database as the database's root user.
- Login or register to post comments
- Printer-friendly version
- 1356 reads
- PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
digiKam 7.7.0 is releasedAfter three months of active maintenance and another bug triage, the digiKam team is proud to present version 7.7.0 of its open source digital photo manager. See below the list of most important features coming with this release. |
Dilution and Misuse of the "Linux" Brand
|
Samsung, Red Hat to Work on Linux Drivers for Future TechThe metaverse is expected to uproot system design as we know it, and Samsung is one of many hardware vendors re-imagining data center infrastructure in preparation for a parallel 3D world. Samsung is working on new memory technologies that provide faster bandwidth inside hardware for data to travel between CPUs, storage and other computing resources. The company also announced it was partnering with Red Hat to ensure these technologies have Linux compatibility. |
today's howtos
|
Recent comments
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago