I am trying to move a single MySql database to another physical disk in my Ubuntu machine. I am using Ubuntu 17.04. the external drive is mounted in /etc/fstab as follows (last line): #zoneminder

By initialising I meant initialising the MariaDB data directory and creating the system tables in the mysql database, if they do not exist. Check the ownership of your MariaDB data directory, it …

I have a Ubuntu server with a Mysql daatabase. I would like to set up an automatic backup of this database during the night on another server (ovh for example).

I want to install MySQL and create a database on it using the following code: sudo apt-get install mysql-server mysqladmin -h localhost -u {username} -p create lrs I get the following message …

Aug 1, 2017 · The manual is missing a step that describes how to create a MySQL database and user for WordPress - the final result. How to do that, under consideration scenario, is …

Also, when I log into MySQL from the command line use the commands SHOW GRANTS and SHOW DATABASES for root and phpmyadmin users I get confirmation of the information …

I face a problem with the access to MySQL. I need to create and import a database but my default user have no necessary privileges to do it. I am using Ubuntu 16.04, additional details about …

The problem is that if i login with root user i can take a mysqldump without problem. But if i login with user account i get permission denied and i must run sudo su first.

Aug 18, 2015 · In /etc/mysql/my.cnf check datadir for a valid directory and that this directory holds your databases and that you can write to that directory. You can do the 1st with grep datadir …

Jul 12, 2016 · So far, I installed mysql-server mysql-client libmysqlclient-dev, and I was suppose to tell MySQL to create its database directory structure where it will store its information using …