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
Top comments (0)