PDA

View Full Version : [ubuntu] Pls need help regarding MySql configuration



futureal2032
November 30th, 2010, 11:44 AM
Hi all,
I am using Ubuntu maverick 10.10 desktop

I have installed LAMP on that..
I have installed phpMyAdmin

the IP of my ubuntu machine is 192.168.1.10

whn i access 192.168.1.10/phpmyadmin via any browser froma windows machine o network..i get the phpmyadmin screen and i can do the database stuff...

But when I try to connect to the MySql server from any other tool it gives me error "can't connect to mysql server"

on Ubuntu machine...i tried to check if mysql server is running.. but even if i type "mysqladmin version" as "root"

it gives me error "Access denied for user 'root'"
i have tried with login other than root but it still gives me the samme error..

How do i start mysql server?
How do i enable access to mysql server from pother machine over the network?
phpmyadmin shows me user "root" already enabled with all priviledges but no matter what command i type in terminal..it gives me error "Acces denied for that user"

How do i start mysql server.. i tried it the old way "/etc/init.d/mysql start" it gave me message use "service mysql start" command..
when i do "service mysql start" it gives me error Start: Rejected

pls help as i am stuck here..and dont know what to do