Go Back   Computer Forums > General Computing > Server Administration
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 07-30-2008, 03:25 PM   #1
Fully Optimized
 
hascet's Avatar
 
Join Date: Jul 2006
Posts: 3,218
Default MySQL on Ubuntu Server

I'm trying to setup a MySQL database on a Ubuntu LAMP server and when I try to change the root password with this:$ mysqladmin -u root password MyPasswordHere, I get this error message:
Quote:
sean@ubuntuwebserver:~$ mysqladmin -u root password masterass1
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
__________________

__________________
www.crazycomputers.org
hascet is offline   Reply With Quote
Old 07-30-2008, 04:24 PM   #2
Golden Master
 
DJ-CHRIS's Avatar
 
Join Date: Apr 2006
Posts: 5,203
Send a message via AIM to DJ-CHRIS Send a message via MSN to DJ-CHRIS Send a message via Yahoo to DJ-CHRIS
Default Re: MySQL on Ubuntu Server

I don't think there is a root password by default on an install of mySQL, so you should be able to login to the database and change the password from there.
__________________

DJ-CHRIS is offline   Reply With Quote
Old 07-30-2008, 05:22 PM   #3
Fully Optimized
 
hascet's Avatar
 
Join Date: Jul 2006
Posts: 3,218
Default Re: MySQL on Ubuntu Server

How would I log into the database?
__________________
www.crazycomputers.org
hascet is offline   Reply With Quote
Old 07-31-2008, 10:51 AM   #4
In Runtime
 
ColdwaterCS's Avatar
 
Join Date: Feb 2005
Posts: 256
Default Re: MySQL on Ubuntu Server

either install webmin or instill phpmyadmin by doing this sudo apt-get install phpmyadmin.
__________________
Now Open @ http://timscomputerrepair.net
Building Custom Computers/Servers and Selling Computer Equipment.
ColdwaterCS is offline   Reply With Quote
Old 07-31-2008, 11:04 AM   #5
Fully Optimized
 
hascet's Avatar
 
Join Date: Jul 2006
Posts: 3,218
Default Re: MySQL on Ubuntu Server

I installed phpmyadmin but I go to http://ip/phpmyadmin and it doesn't exist.
__________________
www.crazycomputers.org
hascet is offline   Reply With Quote
Old 07-31-2008, 01:05 PM   #6
In Runtime
 
ColdwaterCS's Avatar
 
Join Date: Feb 2005
Posts: 256
Default Re: MySQL on Ubuntu Server

depending how you got it installed it should go http://localhost/phpmyadmin or yourdomain.com/phpmyadmin or if you got it correctly installed right.
__________________
Now Open @ http://timscomputerrepair.net
Building Custom Computers/Servers and Selling Computer Equipment.
ColdwaterCS is offline   Reply With Quote
Old 07-31-2008, 01:23 PM   #7
Fully Optimized
 
hascet's Avatar
 
Join Date: Jul 2006
Posts: 3,218
Default Re: MySQL on Ubuntu Server

Right, but I try to go to it through http://myip/phpmyadmin and it says it doesn't exist...what could have gone wrong?
__________________
www.crazycomputers.org
hascet is offline   Reply With Quote
Old 07-31-2008, 05:12 PM   #8
In Runtime
 
ColdwaterCS's Avatar
 
Join Date: Feb 2005
Posts: 256
Default Re: MySQL on Ubuntu Server

did you restart apache? if you didnt you might want to do that.
__________________
Now Open @ http://timscomputerrepair.net
Building Custom Computers/Servers and Selling Computer Equipment.
ColdwaterCS is offline   Reply With Quote
Old 08-01-2008, 06:28 PM   #9
Fully Optimized
 
hascet's Avatar
 
Join Date: Jul 2006
Posts: 3,218
Default Re: MySQL on Ubuntu Server

Quote:
Originally Posted by ColdwaterCS View Post
did you restart apache? if you didnt you might want to do that.
Ha! That did the trick, thanks so much!
__________________
www.crazycomputers.org
hascet is offline   Reply With Quote
Old 08-01-2008, 07:56 PM   #10
In Runtime
 
ColdwaterCS's Avatar
 
Join Date: Feb 2005
Posts: 256
Default Re: MySQL on Ubuntu Server

just remember this if you have anymore problems just restart apache. and also dont feel bad I am still a newbie on ubuntu/apache 2.
__________________

__________________
Now Open @ http://timscomputerrepair.net
Building Custom Computers/Servers and Selling Computer Equipment.
ColdwaterCS is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 09:40 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0