How To Install And Configure WAMP 3.2.3 Server On Windows 10 20H2
What is a WAMP server? WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdmin allows you to manage easily your databases. What are we going to install? WAMP Server with Apache 2.4.46 , PHP 7.3.21 (you can go higher if you […]
How to install XAMPP in Ubuntu \ Lubuntu Linux
This is a simple tutorial on how to install XAMPP on our Linux machine. XAMPP is the most popular PHP development environment. XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. Website to download XAMPP Commands: A simple video on how to install: We hope you enjoyed this article. if that is so […]
How To Install And Configure XAMPP 8.0.3 on Windows 10
What is XAMPP? XAMPP is the most popular PHP development environment XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use. Why use XAMPP? Not everyone is used to using Linux servers, […]
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.
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.
Ubuntu mycli install (mysql terminal – modern alternative to the default MySQL client)
Mycli is a modern alternative to the default MySQL client. This tool does to MySQL what bpython does to the standard Python REPL. Mycli will auto-complete keywords, table names, columns, and functions as you type them. The completion suggestions are context-sensitive. For example, after the SELECT * FROM, only tables from the current database are […]
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.