newb having problems with databases

[thesimplecreator]

ok, ive installed apache,mysql,and phpmyadmin on my computer,
the website works when i make hp file and stuff like that,

but when i go to use phpmyadmin and log in as admin with the password being blank, it says i dont have permission to create databases.

and when i try to log on as my normal account, it doesnt let me log on and it says:
#1045 - Access denied for user 'cody'@'localhost' (using password: YES)

im a newb at mysql,servers,etc.
so im not sure what i should do or how i should do it so it will let me add databases.

[jledhead]

if this is all a default install have you tried root and no password?

[thesimplecreator]

yes this is a default install,
when i try root with no pass i get
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
on phpmyadmin

[jledhead]

what distro and how did you install all of this?

[thesimplecreator]

im on ubuntu 8.04 hardy
i installed all of it through synaptic package manager

[jledhead]

and you install mysql-server?

here is something to try from an ubuntu guide

Set mysql root password

Before accessing the database by console you need to type:

mysql -u root

At the mysql console type:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

taken from here
https://help.ubuntu.com/community/ApacheMySQLPHP

report back how it goes

[thesimplecreator]

ok... this is what i got when i entered it in

cody@ubuntu:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
cody@ubuntu:~$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
mysql>

[davidanand]

Hey
I feel that your mysql password is wrong .. try changing the mysql password
use the following links
Resetting a forgotten MySQL root password
David's Dairy: Reset mysql root password when lost
and try login now....

[elija]

When you installed mysql-server it will have asked you for a root password

[thesimplecreator]

ohh. well i reinstalled ubuntu becuase of an unrelated problem yesterday morning, so thanx for the help ill keep it in mind when i reinstall apache and mysql