MySql

A man sitting at a table with a laptop and a cup of coffee.

Reset MySql 8.0 root password on Windows

If you forgot your root password and need to reset it for your MySql 8 server. Follow below guide. Stop MySQL80 service on Windows This will stop the MySQL80 service. If you wish to stop service from the services console, you can go to Start menu, select Control Panel, then Administrative Tools, then Services. Okay,

A person drawing a diagram on a piece of paper.

How to create new MySQL user and assign database

To create a new user in MySQL follow the below steps: Create new MySQL user Once the user is created, you will need to set permissions to grant access to the database. Here I will first create a testdb to create a new database to set permissions. Create new database Assign permissions to database Update

An image of a stage with lights and cubes.

How to install MySQL 8 on CentOS 8

Download rpm package and configure yum repository Disable mysql5.7: Enable mysql8.0: Verify: Disabling default MySQL modules Installation Service start stop start: status check: Changing temp password after installation The above output will display the default password Z#5m,9wsmlw in the console. Changing password by following below setup command Interactive setup: Connecting to MySQL server

Scroll to Top