I wanted to locate the route where my databases are hosted, with the aim of configuring a .bat file to make automatic backups.
On the server where I have the PHPMYADMIN installed, I do the following, showing the following databases, and mine do not appear.
However, if I access through phpmyadmin these are the databases:
What am I doing wrong? How can I show my databases through the windows command window?
It seems that the user "root" does not have permissions for those tables.
You can connect to mysql with the user you use for phpmyadmin, and then launch the following commands;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
And then the command;
FLUSH PRIVILEGES;
In phpmyadmin the root user already has privileges in the databases:
The databases "sakila" and "world" do not exist when I enter the browser in the phpmyadmin, it seems as if the directory I access through the command window was different from the database directory that I access through the browser with phpmyadmin.
I do not know, I'm a bit lost, does anyone have any idea what might be happening?
If I go to the directory: C: \ xampp \ mysql \ data, if I find the databases I see with phpmyadmin, but I can not see them through the command window.