cant get mysql and phpmyadmin working :(
Posted: 11. January 2006 19:04
Hello!
here are my problems...
i have a debian linux server, with xampp installed...
Everything is working fine, but i have problems with mysql and (or) phpmyadmin.
i can acces phpmyadmin through browser (mydomain/phpmyadmin)
but, as root, i have no privileges, and also get this message:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
BUT. I tried to set mysql password with, lampp security, but it says:
XAMPP: MySQL has a root passwort set. Fine!
also i tried to set password in /lampp/phpmyadmin/config.inc.php, where http checking is used, and username is root!
no success...
so, how can i set the root password for mysql, or how can i see what password is used?(i dont remember setting any at installation)
the second problem is, how can i run mysql at all?
usually this goes something like "mysql -u username -p password"
but i cant anyhow run mysql, always get unknown command error.
also "locate mysql" says theres no such file!
though in running processes i can see mysql running..
i thought i could solve the first problem, if i could get into mysql console.. BUT I CANT
please someone help me out, i have no ideas any more.. and, excuse my English language, which is not my best quality
Thanks for help...
here are my problems...
i have a debian linux server, with xampp installed...
Everything is working fine, but i have problems with mysql and (or) phpmyadmin.
i can acces phpmyadmin through browser (mydomain/phpmyadmin)
but, as root, i have no privileges, and also get this message:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
BUT. I tried to set mysql password with, lampp security, but it says:
XAMPP: MySQL has a root passwort set. Fine!
also i tried to set password in /lampp/phpmyadmin/config.inc.php, where http checking is used, and username is root!
no success...
so, how can i set the root password for mysql, or how can i see what password is used?(i dont remember setting any at installation)
the second problem is, how can i run mysql at all?
usually this goes something like "mysql -u username -p password"
but i cant anyhow run mysql, always get unknown command error.
also "locate mysql" says theres no such file!
though in running processes i can see mysql running..
i thought i could solve the first problem, if i could get into mysql console.. BUT I CANT
please someone help me out, i have no ideas any more.. and, excuse my English language, which is not my best quality
Thanks for help...