mysql

[Jerry McBride]

On Sun, 23 Mar 2003 15:34:29 -0800 Ted Ozolins <ted1 at telus.net> wrote:

> I must be over-looking some basic step in setting up (or attempting to)
> mysql.
> This is on a Slackware-8.1 box.I have done the "mysql_install_db;
> mysqladmin -u <user> -p password 'new-pasword' I then use "safe_mysqld
> &" to start mysqld .. then when I try to create or do anything I keep
> getting 
>  mysqld Enter password:
> mysqladmin: connect to server at 'localhost' failed

Are you doing this as root?

> error: 'Access denied for user: 'ted at localhost' (Using password: YES)'

Are you doing this as user TED?

> Any thoughts? I missed something of that I'm sure. I've read the FM over
> and over again but I can't see what I've missed. I followed (HTML docs)
> to the letter and still no joy. Should setting up mysql be this
> illusive?
> 

Yup. It can be a total nightmare first time around. Even second, third, etc...
Log in as root, ping localhost for fun, then run mysqladmin and try to create
and then delete a couple of databases... if that works then you are in. Run
mysqladmin again and create your real database. Fireup mysql, access your new
database and setup permissions for user TED and ROOT coming in from both
localhost and whatever ip you wish. Quit mysql and then run your application, or
whatever you have to use your new database as user TED or ROOT.


-- 

******************************************************************************
                     Registered Linux User Number 185956
          http://groups.google.com/groups?hl=en&safe=off&group=linux
             Join me in chat at #linux-users on irc.freenode.net
This email account no longers accepts attachments or messages containing html.
     9:23pm  up 75 days,  2:57,  4 users,  load average: 0.08, 0.04, 0.06