database user does not have the permission to do select query. you can grant the permission to the user if you have root access to mysql http://dev.mysql.com/doc/refman/5.1/en/grant.html Your second query is on different database on different table. And the user you are connecting with does not have permission to access data from this database or … Read more
If I do SHOW GRANTS in my mysql database I get If I am not mistaken, root@localhost means that user root can access the server only from localhost. How do I tell MySQL to grant root the permission to access this mysql server from every other machine (in the same network), too?
IMPORTANT: do NOT delete ibdata1 file. You could destroy all your databases. Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps: Rename folder mysql/data to mysql/data_old Make a copy of mysql/backup folder and name it as mysql/data Copy all your database folders from mysql/data_old into mysql/data (except … Read more
TL;DR: To access newer versions of mysql/mariadb as the root user, after a new install, you need to be in a root shell (ie sudo mysql -u root, or mysql -u root inside a shell started by su – or sudo -i first) Having just done the same upgrade, on Ubuntu, I had the same issue. What was odd was that Would accept … Read more
Since you used the Windows installer, everything is set up for you to run MySQL 5.7 as a Windows service, which is a great option in most cases. Instead of running mysqld.exe from the command line, Win + R Run services.msc Right-click on MySQL57 Start the service.
You can use a CASE statement:
From Save MySQL query results into a text or CSV file: Note: That syntax may need to be reordered to in more recent versions of MySQL. Using this command, columns names will not be exported. Also note that /var/lib/mysql-files/orders.csv will be on the server that is running MySQL. The user that the MySQL process is running under must have permissions … Read more
Just found it, it is /etc/my.cnf
from command line you can use: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
In case MySQL Server is up but you are still getting the error: For anyone who still have this issue, I followed awesome tutorial http://coolestguidesontheplanet.com/get-apache-mysql-php-phpmyadmin-working-osx-10-9-mavericks/ However i still got #1045 error. What really did the trick was to change localhost to 127.0.0.1 at your config.inc.php. Why was it failing if locahost points to 127.0.0.1? I don’t know. But it worked. ===== … Read more