Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Hi geeks ,
I recently installed mysql server on fedora 10 with yum command.
"#yum install mysql-server" and sucessfully completed installation.but what is default root password?i cant access db as root. Ive already spend some time googling over the net and found some threads saying that default password is blank and to access with the following command
#mysql -u root -p
but i cant solve the problem yet. When i type above command, i am asked for password. but 'blank' is not root passwd. help me please ..
sorry if this thread is not appropriate to this forum ..
# service mysqld start
Starting MySQL: [ OK ]
# mysqladmin -u root password 'rootpasswd'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
hope this will work:
in terminal type,
mysqladmin -u root yournewpassword [press enter]
then use mysql -u root -p then press enter:
type the password above to connect to mysql,
to see all the database ==> show databases;
to select data base ==>use dbname;
to see all the tables inside a db ==> show tables;