Easy MySQL Database Administration, Creating Users and Assigning Privileges

Connect to MySQL: You can connect to your MySQL server using the MySQL command-line tool or a database management tool like phpMyAdmin. To use the command-line tool, open your terminal and run: mysql -u root -p You’ll be prompted to enter the root user’s password. Create a MySQL Database: To create a new database, use the CREATE DATABASE statement. Replace <database_name> with the desired name of your database: CREATE DATABASE <database_name>;...

October 20, 2023 · 2 min · 301 words · Saman Wijesinghe