developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
37
results
Andrew Fletcher
•
When attempting to backup mysql using the mysqldump command
mysqldump -u root -p database_name > backup.sqlHowever, it is throwing an error:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespacesWhat to do?
Reading through the mysqldump documentation, you need use --no-tablespaces. So the command becomes
mysqldump -u root -p database_name > backup.sql...
Andrew Fletcher
•
How to Create New MySQL User
Before you can create a new MySQL user, you need to...
Andrew Fletcher
•
You can create a new date/time format by navigating to:
Admin ->...
Andrew Fletcher
•
The generally accepted answer to a mysqldump is:
mysqldump -h [host] -u...
Andrew Fletcher
•
Time is essential to all of us... and if you are like me there is never enough...
Andrew Fletcher
•
To add ejabberd and run MYSQL to the server I needed to update the server version of mysql from 5.5 to 5.7. Fortunately, there are great instructions on the Plesk support page regarding how to achieve this outcome.
https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux
As a point of reference, as I worked through the steps... step 10 you need to restart the MYSQL server. This is a quick progress by...
Andrew Fletcher
•
The starting point is to read through and follow the notes outlined on the...