Search Results

Problem: An apache Tomcat application could not connect to the mysql database. The user was defined as username@localhost. The error displayed was: "#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server" Solution: Ensure that in /et...

(2023-05-02) You can use the CURRENT_USER and USER functions as follows: SELECT CURRENT_USER(); SELECT USER(); CURRENT_USER shows who you are authenticated as, while USER shows who you tried to authenticate as.

The Theory Backup: #!/bin/bash for i in `echo "show databases" | mysql -u mysql | grep -v Database`; do echo $i mysqldump --databases $i --opt --user=root --password=$PASSWORD > /usr/tmp/mysql/$i.dump done Restore: # mysql -u root < $DATABASE.d...

(2019-02-28) List tables in a database SHOW TABLES List columns in a table SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable;