[CoLoCo] MySQL on Feisty

[Collins Richey]

On 10/9/07, TJ Heaney <tjheaney at gmail.com> wrote:
> Hey all,
>
> Quick Question.
>
> Trying to get MySQL all set up and configured, looks like everything
> installed, but, when I try to log in, it says invalid username/pwd
>
> How do I edit that to give me access?
>
> Should I just chmod the /usr/bin/ so I have access?
>
> I am using kmysqladmin for a front-end.
>

I would recommend you actually read the MySQL manual (Google for
that). MySQL or PostgreSQL or Oracle or ??? does not use the
Linux/Unix userid/password system. You have to add a MySQL
userid/password via MySQL commands (look up the GRANT statement).

On a default MySQL install, the root user can login to 'mysql' with no
password. Use GRANT statements to add your own user and set a password
for root.

Good luck.

-- 
Collins Richey
     If you fill your heart with regrets of yesterday and the worries
     of tomorrow, you have no today to be thankful for.