basic mySQL for linux

from the console

login to mysql
#mysql -u root -p
#enter your pass

show database –> #show databases;
create database –> #create database idlewood;
delete database –> #drop database idlewood;

if you forgot mysql root password – please make sure -p and old password that no space between
#mysqladmin -u root -pmysqlRootPassword password ‘newpassword’

About Damon Luong

San Jose, California
This entry was posted in My Linux, mySQL. Bookmark the permalink.