I have fresh installed Mysql with php5, and i was following the instruction at page https://help.ubuntu.com/community/ApacheMySQLPHP. The problem is, i couldn't get the exact output as the page shown, such as
mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
It just kept saying access denied for user 'root'@'localhost'
and i saw the info at other page, it says need to add a line at somewhereelse, but, they didn't mention which file and under which directory to edit. So i have been stuck for few days and still can not figure out how to create an user for mysql and to add a new database.
Anyone can please point out the problem? Thanks!