Monday, 10 December 2018

RESTful web services mysql-udf-http

›
wget http://curl.haxx.se/download/curl-7.21.1.tar.gz tar zxvf curl-7.21.1.tar.gz cd curl-7.21.1/ ./configure --prefix=/usr make &amp...
1 comment:
Thursday, 22 February 2018

Rsolved ERROR 1290 (HY000): INTO OUTFILE CSV FILE

›
Rsolved ERROR 1290 (HY000): INTO OUTFILE CSV FILE The MySQL server is running with the --secure-file-priv option so it cannot execute this...
Wednesday, 3 January 2018

Solved ERROR 2027 (HY000): Malformed packet

›
Unable to connect mysql server remotely , The connection seems OK it might because of  mysql client bug  You need to update or downgrade...
Thursday, 26 October 2017

Solved ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

›
A error occured when run `mysql` from the terminal to connect to a server. Add `--skip-secure-auth` to the end of the statement mysql -u...
Friday, 20 October 2017

mysql flush commands

›
List of all mysqladmin flush commands. flush-hosts: Flush all information in the host cache. flush-privileges: Reload the grant tables ...
Thursday, 11 May 2017

Mysql dba tips and tricks: ERROR 1044 (42000): Access denied for user Restor...

›
Mysql dba tips and tricks: ERROR 1044 (42000): Access denied for user Restor... : Access denied for user 'root'@'%' I am ...

ERROR 1044 (42000): Access denied for user Restore the MySQL root user’s full privileges?

›
Access denied for user 'root'@'%' I am able to login fine :  mysql -u root -p mysql>  GRANT SELECT, LOCK TABLES,EXE...
Sunday, 9 April 2017

How to understand the MySQL Slow Query Log

›
How to understand the MySQL Slow Query Log root@server#tail -f /var/log/mysql_slow_query.log # Time: 2017-04-09T20:10:09.472872Z # User...
Monday, 16 January 2017

Counting the number of sleeping connections

›
INFORMATION_SCHEMA, For instance, counting the number of sleeping connections can be done with: mysql> SELECT COMMAND,COUNT(*) TOTAL F...
Wednesday, 11 January 2017

Set up and verify automated MySQL backup in 15 minutes

›
The Solution: Zmanda Recovery Manager for MySQL Zmanda Recovery Manager for MySQL (ZRM for MySQL) simplifies this essential part of datab...