How to show the last queries executed on MySQL?

You can enable a general query log for that sort of diagnostic. Generally you don’t log all SELECT queries on a production server though, it’s a performance killer.

HOW TO SELECT row as COUNT() or how to count rows

SELECT browser, COUNT(browser) AS freq FROM

Grant all privileges to root@localhost for mariadb or mysql on ubuntu 16.04 to use phpmyadmin

If you have ever had a problem to login to phpmyadmin with root you will need to add the rights.login to mariadb/mysql: check if user is added: Now add the root user: And now flush:

HOW TO MySQL DUMP from terminal

You can create mysqldump like this: create config.cnf: Now lets backup a database

How to create MySQL replication server

10.20.6.29 – Master Database10.20.6.30 – Slave Database chnage the bind address to your server real ip address 10.20.6.29 uncomment at the bottom of the file add your databases now log in with root on the mysql server via terminal copy the databases to the slave server with phpmyadminin 10.20.6.30 a.k. the slave If there is […]

MySQL Query where id is not equal to (WHERE id 6)

Have you ever needed a query where you search for all except one thing?Here is an example of a query where you search for all except the number 6: If you have ten users with id from one to ten , number six won’t be in the executed query.

MySQL Create a log file with last queries

You can enable a general query log for diagnostic purposes. Generally you don’t log all SELECT queries on a production server though it, it’s a performance killer.