User Tools

Site Tools


command_line_mysql

Command Line MySQL


Here are a few useful MySQL commands you can run from the command line, handy if you have installed MySQL and you don't have desktop access or a graphical MySQL manager application.

Login to MySQL First we must login
mysql -u root -p — (the root part assumes root is your mysql username)

Create a MySQL Database
CREATE DATABASE new_database; — (don't forget the semicolon ; it's really important)

Show a MySQL Database
SHOW DATABASES;


command_line_mysql.txt · Last modified: 2023/03/09 22:35 by 127.0.0.1