MySQL 5.7 command in shared hosting with SSH
show variables like ‘datadir’;
My Work Diary
First connect to your hosting server with SFTP / SSH account user name and password, then run the command: mysql -u databasename -h databaseHosting -p databasename...
Open a CMD as Administrator. started off in c:\Windows\system32. cd config\systemprofile\AppData\Local mkdir TileDataLayer cd TileDataLayer mkdir Database
in my case, the mariadb / mysql is 32bit, as you knew 32bit only support about 3GB RAM, so instead of allocated 4GB,I changed it to...
The best bet: Turn off query cache: find my.ini in windows, or my.conf in linux add line in mysqld [mysqld] … query_cache_type=0 query_cache_size=0 0 is off...