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, […]
Reset MySql 8.0 root password on Windows Read More »
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
How to create new MySQL user and assign database Read More »
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
How to install MySQL 8 on CentOS 8 Read More »
NOTE: This tutorial assumes you know how to connect to a Kubernetes cluster. Create secrets to securely store MySQL credentials Output: Persistant volume and MySQL deployment Execute the below command to create persistent volume: Output: Execute the below command to deploy MySQL pod: Output: Exposing MySQL as a Service Output: Output:
How to Deploy MySQL database on Digital Ocean Managed Kubernetes Cluster Read More »
