Results 1 to 10 of 10
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 12-22-2008 #1
newb having problems with databases
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.
- 12-22-2008 #2
if this is all a default install have you tried root and no password?
- 12-22-2008 #3
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)
- 12-22-2008 #4
what distro and how did you install all of this?
- 12-22-2008 #5
im on ubuntu 8.04 hardy
i installed all of it through synaptic package manager
- 12-23-2008 #6
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');
report back how it goes
- 12-23-2008 #7
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>
- 12-28-2008 #8
- Join Date
- Apr 2008
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....Regards
-->Success is the list of failures ...!!!
- 12-28-2008 #9
When you installed mysql-server it will have asked you for a root password"I used to be with it, then they changed what it was.
Now what was it isn't it, and what is it is weird and scary to me.
It'll happen to you too."
The Fifth Continent
- 12-28-2008 #10
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