[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] Starting SQL? RAQ3



This works on a raq 4 running a mysql server.

telnet to server
login to mysql with
mysql -u root -p<enter>
enter root password

The mySQL prompt will show
enter
create database database-name;

enter
grant select, insert, update, delete, create, drop, alter, index
on database-name.*
to user-name@localhost
identified by 'password';

The above can be entered on one line or you can press enter after each line.
The command is ended with a semi-colon.

Hope this helps,
David
PageKeeper Service 505-892-8723


----- Original Message -----
From: "FantasticMoms.com" <admin@xxxxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Tuesday, September 03, 2002 9:40 PM
Subject: [cobalt-users] Starting SQL? RAQ3


> Can anyone tell me how to "start again" with MySQL?
>
> It seems I keep getting this error :
> ERROR 1045: Access denied for user: 'user@xxxxxxxxxxxx' (Using password:
> YES)
>
> ... and I would dearly like to reset everything, then find a good tutorial
> to learn this.  Can anyone point me in the direction of a good tutorial
> please?
>
> I thought I was getting somewhere, until I made this page and just saw
> nothing but errors :
> http://www.2hosts.com/sqltest.php3
>
>
>
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>
>