Reset the MySQL OR MariaDB Root Password

To change the MySQL/MariaDB root password, follow these steps: Ensure that the MySQL/MariaDB server is running. Open a new Linux terminal. Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax: mysqladmin --user=root password "newpassword"OR ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...

View More
  Dibaca 900 kali

MySQL: ERROR 1040: Too many connections

This basically tells that MySQL handles the maximum number of connections simultaneously and by default it handles 100 connections simultaneously. These following reasons cause MySQL to run out connections. Slow Queries Data Storage Techniques Bad MySQL configuration I was able to overcome this issues by doing the followings. Open MySQL command line tool and type, show variables like "max_connections"; This will return you something like this. +-----------------+----- ...

View More
  Dibaca 985 kali

CRUD SQLITE menggunakan CMD

Tutorial CRUD SQLITE menggunakan CMD Simak Videonya Dibawah ini   ...

View More
  Dibaca 928 kali

TUTORIAL READ INSERT UPDATE DALETE MYSQL MENGGUNAKAN CMD

VIDEO TUTORIAL READ INSERT UPDATE DALETE MYSQL MENGGUNAKAN CMD simak videonya dibawah ini ...

View More
  Dibaca 877 kali