Jump to content


Photo

help with setting up MySQL


  • Please log in to reply
3 replies to this topic

#1 gtludwig

gtludwig
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 01 September 2006 - 02:55 PM

Hello all,

I'm a newbie here so, please, have a little patience with me! :D

I'm setting up a LAMP server at work. The L is Ubuntu 6.06, the A is Apache2, M is MySQL and P is PHP5. All is working but MySQL. Each time I try to set up MySQL I get this:

root@rx160:~!# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@rx160:~#

I'm running out of ideas as how to get my application running. The goal is to run as test NetOffice to manage my company's projects.

Thanks in advance!

Gustavo

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 01 September 2006 - 03:25 PM

Add the -p command after -u root

So its
mysql -u root -p
When you hit return it should now prompt for the password for the root user.

#3 gtludwig

gtludwig
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 01 September 2006 - 09:09 PM

Ok, I've done that and it prompted me for a password. But the same error occurred again.

I don't think I have a root user registered in this installation of MySQL. How can I check that out?

I'm thinking of removing everything MySQL related and restarting from scratch. How can I make sure to remove everything and set it up again? Will only:
# apt-get remove sql-server
do the trick? I've tried this already and after:
# apt-get install sql-server
the same error keeps returning.

I really don't want to re-install Ubuntu, but if it's what it takes to run, so be it!

Thanks again!

Gustavo

#4 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 01 September 2006 - 09:49 PM

well by default mysql will install a defualt user, which is root with no password. I am not experienced with installing apps in linux so I cant help you there. If are using ubuntu prehaps have a read of this guide over at help.ubuntu.org for installing Apache Mysql and PHP on Ubuntu




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users