Home / ubuntu / Questions / 411961
Accepted
black
Asked: 2014-01-28 23:33:54 +0800 CST

mysql server in ubuntu 13.04 not showing databases

  • 772

i have installed Xampp(LAMPP) in Ubuntu 13.04 . i have secured the xampp phpmyadmin Mysql FTP. status showing ACTIVATED.now, i have installed mysql server.in terminal write mysql -u root -p and then password and i connect with my mysql commandline. now SHOW DATABASES; i can only see information_chema,performance_schema and test mysql and also showing db(abc) the created databases from the terminal command line. i can drop this 'abc' database from terminal but abc is not showing in phpmyadmin.and databse created in phpmyadmin not showing in terminal with show databses;. also could not drop databases from phpmyadmin drop database statements are disabled allowing me to create only.

thnks for any help.

server

1 Answers

  1. Best Answer

    Looks like there is another mysql-server running in your computer. So when you log in to mysql using terminal, you are loggin into that one (Not the XAMPP one). To connect to mysql server in XAMPP you have to run /opt/lampp/bin/mysql -u root

    • 2