MySQL command

To create a new MySQL user account run the following command: CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘user_password’; To grant access from another host change the hostname part (localhost) with the remote machine IP. For example, to grant access from a machine with IP 10.8.0.5 you would run: CREATE USER ‘newuser’@’10.8.0.5’ IDENTIFIED BY ‘user_password’; Copy To […]

En Lire Plus

How to create a MySQL database

MySQL est loin d’être facile à mettre en œuvre ! Toutes les commandes doivent être entrées par une invite de commande, il n’y a pas d’interface visuelle. C’est pourquoi il faut avoir de bonnes connaissances en programmation pour créer et manipuler une base de données, sans quoi vous risquez de perdre beaucoup de temps, voire […]

En Lire Plus

MySQL Change a User Password

would like to change a password for a user called tom using UNIX / Linux command line option. How do I change a user password under MySQL server? You need to use mysql (or mysql.exe on MS-Windows based system) under Linux or Unix like operating system. Open a terminal / ssh session. Type the following […]

En Lire Plus

Bash script to backup all your MySQL databases

Backing up all your MySQL databases one by one is a pain. Here is a small bash script I made to dump and compress all my databases to my Dropbox folder. The script will skip any database whose name starts with an underscore, so I can have test or junk databases that I don’t want to […]

En Lire Plus

MySQL Change root Password

How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session? Setting up MySQL password is one of the essential tasks. By default root user is MySQL admin account user. Please note that the Linux / UNIX root account for your operating system and MySQL […]

En Lire Plus

Create MySQL database and new user account on shell

When you try to access MySQL database server from client such as mysql or even programming language such as php or perl you need a user account. MySQL has sophisticated user management system that controls who can access server and from which client system. It uses special tables in mysql database. In order to create […]

En Lire Plus