Linux:CREATE: command not found

Problem:CREATE: command not found

Error

Solution:
Step 1: First set MYSQL environment variable in Ubuntu
Step 2:login using username and password
In root vi .bashsrc

export PATH=$PATH:/opt/lampp/bin

====================or===================

other than root user

ALTER USER 'root'@'localhost' IDENTIFIED BY 'pws?~,F(?Fkdfgbdfb';
FLUSH PRIVILEGES;

====================OR=======================

ALTER USER 'wizbrandos'@'localhost' IDENTIFIED BY 'myphpmyadminpassword';
FLUSH PRIVILEGES;

Set db name,username and pwd