MySql error 1044 (fedora 11)
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
#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
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:
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..!