running webadmin for years now - and having troubles for months - and posting here for weeks. But the support seems to be not the best...
want to run sql-commands on the newest version - but it fails all the time
USE jo ;
SHOW GLOBAL VARIABLES LIKE 'PORT';
gives back the following
Failed to execute SQL : SQL USE jo ; SHOW GLOBAL VARIABLES LIKE 'PORT'; failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW GLOBAL VARIABLES LIKE 'PORT'' at line 1
while
USE jo ;
SHOW GRANTS FOR CURRENT_USER;
gives back the following
Failed to execute SQL : SQL USE jo ; SHOW GLOBAL VARIABLES LIKE 'PORT'; failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SHOW GLOBAL VARIABLES LIKE 'PORT'' at line 1
hmm - i have no ideas why the comands fail all the time!?
see the manual on this sql-command: https://beginner-sql-tutorial.com/sql-use-database.htm
SQL USE Statement The USE Statement is used to select a database and perform SQL operations into that database. The database remains default until end of session or execution of another USE statement with some other database.
SQL USE DATABASE Statement: The Syntax for the USE Statement is:
USE database_name; database_name - is the name of the database to be selected
USE DATABASE Example: If you want to use database MyDatabase, the statement would be like USE MyDatabase ;
btw i am running the versions MySQL version 5.5.33 PHP 5.6.39
update
by the way: if i do not use USE then it works propperly
if i run
SHOW GLOBAL VARIABLES LIKE 'PORT';
Output from SQL command SHOW GLOBAL VARIABLES LIKE 'PORT'; ..
or
SHOW GRANTS FOR CURRENT_USER;
i get outputs like this one
Output from SQL command SHOW GRANTS FOR CURRENT_USER; ..
Grants for root@localhost
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*4444444rrrrrrwwwww222222444443660283C379783ED8EF54B6EC01DAF8374444444rrrrrrrrrrrreeeeewwwww2CeC3C474F4' WITH GRANT OPTION
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
and now i have to rethink what this does want to say in the context of a - error in trying to establish a db-connection - while installing a wordpress on the frontend
