mysql modes

/usr/share/mysql my-huge.cnfmy-large.cnfmy-medium.cnfmy-small.cnf just rename to my.cnf or MySQL config file in the respective location

Restore database in mysql

A common use of mysqldump is for making a backup of an entire database: shell> mysqldump db_name > backup-file.sql You can load the dump file back into the server like this: UNIX shell> mysql db_name < backup-file.sql The same in Windows command prompt: mysql -p -u [user] [database] < backup-file.sql PowerShell C:> cmd.exe /c “mysql -u root -p db_name … Read more

How to Back Up and Restore MySQL Databases with Mysqldump

Mysqldump Command Syntax Before going into how to use the mysqldump command, let’s start by reviewing the basic syntax. The mysqldump utility expressions take the following form: mysqldump [options] > file.sql Copy options – The mysqldump options file.sql – The dump (backup) file To use the mysqldump command the MySQL server must be accessible and running. Backup a … Read more

How To Create a New User and Grant Permissions in MySQL

Introduction MySQL is an open-source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial will give a short overview of a few of the many options. What the Highlights Mean Throughout this tutorial, any lines that … Read more

Connect to a MySQL database remotely

In order to perform these steps, you must have local server access to log in as the root MySQL user. Retrieve your IP address You need to know the Internet Protocol (IP) address of the computer from which you’re connecting. You can retrieve this information by visiting one of the following sites: https://icanhazip.com https://www.whatismyip.com Grant access Perform … Read more

Pin It on Pinterest

Open chat