Hi folks,
I am installing MySql on Linux (Fedora core 11). Basically I am newbie & wana create a PHP application. I am done with PHP & Apache installation.
I am facing some serious problems while Installing Mysql.
below are all the tried codes & the outputs/errors:
#yum install mysql mysql-server
#chkconfig --levels 235 mysqld on
#/etc/init.d/mysqld start
#mysqladmin -u root password yourrootsqlpassword
in my case which exactly looks like
# mysqladmin -u root 'root_password' 'newroot_password'
the output is
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Here I am confused abt the root password, as to what password exactly I have to enter here. Since I had never set a password for Mysql as far as I remember. I had removed & reinstalled the MySql packages.
Then I even tried:
#mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Folks I have tried all possibilities that were mentioned on the Internet & various forums.
Can anyone kindly help me out with the detailed & easliy understandable steps
e.g if the command is :
# mysqladmin -u root password new-password
then what actually I have to enter after root "word password" or "actual_password"
Hope I am able to convey my doubt properly.

However I am able to get into the Mysql prompt with the below code:
#mysql -user=root
but not able to execute the commands like:
mysql> create database salesdata;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'salesdata'

Can anyone plz reply to this on priority.

Thanks in advance..!

The command you have to use is:
# mysqladmin -u root password <your_password>
The only thing you should change is <your_password>. The keyword password is used to tell mysqladmin that it has to change the empty password of user root to the password you provided.

Thanks for the reply, but I have found
the solution in:

http://www.faqforge.com/linux/contro...root-password/

Cheer's..