PDA

View Full Version : installing mySQL



ronnelson929
August 1st, 2005, 05:05 AM
I've got all the packages installed for mySQL, php works, perl works etc. and apache works. I even believe that mySQL works i just can't get permissions to establish / change the password for the username or create a new user. I need to create these things to install moveable type the way that I want to. I can get into the mysql shell but once there i can't perform any operations because i'm not logged in with any privileges. Any ideas? :confused: :confused:

Burgundavia
August 1st, 2005, 05:23 AM
This page may have some information you might want to look at:

https://wiki.ubuntu.com/ApacheMySQLPHP

Corey

Wide
August 1st, 2005, 05:24 AM
Have you set a root password for mysql?

http://ubuntuguide.org/#installmysqldatabaseserver



mysqladmin -u root password db_user_password


replace "db_user_password" with your password


Hope this helps :grin:

ronnelson929
August 1st, 2005, 06:16 AM
root@slacker:/usr/bin # mysqladmin -u root password blank
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

i don't believe that i've given it a password yet. neither of those suggestions have gotten me anywhere. I believe that I am yet again stuck on the mysql system ](*,) ](*,)