Try
GRANT ALL PRIVILEGES ON *.* TO root@'%'
IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
Or you could always do a straight
INSERT INTO user VALUES('%','root',password('mypassword'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
james
---
Nick Wilson wrote:
Well, I'm in !! Now I'
Ah...
Do you have permissions over the mysql directories?
Can you start safe_mysqld as root? (purely for problem solving
purposes ;)
And of course - are your databases in /var/lib/mysql?
james
Nick Wilson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> * and then Gerald Clark
It's OK Nick - it started. It's just writing that to the terminal
window. Hit enter to get the command prompt back (or ctrl-c if that
doesn't work).
james
Nick Wilson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> * and then James Carr
Hi Nick
It'll be something like:
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
Cheers
james
Nick Wilson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi everyone,
> I have searched the archives and read the manual but am at a loss as to
> how to get my
Mysql-front is v.good, www.mysqlfront.de i think.
james
Jerry wrote:
>Does anyone know of a good color coded SQL editor for MySQL that
>works in Windows?
>
>TIA,
>Jerry
>
>
>
-
Before posting, please check:
http://www.m
---
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsub
-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
>&l
PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
James Carrier
Bullet Online :: Aim Higher [http://www.bulletonline.com]
41b Beavor Lane, London W6 9BL
Tel +44 (0) 20 8834 3442
Fax +44 (0) 20 8741 2790
anual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
James Carrier
Hello MySQL users
I was wondering if one of you could advise me on the best solution to a
problem I'm having - I'm sure this has been done before but haven't found
anything in the archives.
Basically the problem I am having is how best to handle multiple values for
a specific column, in this cas
posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try
tiple values.
>--
>Amer Neely, Softouch Information Services
>W: www.softouch.on.ca
>E: [EMAIL PROTECTED]
>V: 519.438.5887
>Perl | PHP | MySQL | CGI programming for shopping carts, data entry
>forms.
>"We make web sites work!"
>
>----------
Hello MySQL users
I was wondering if one of you could advise me on the best solution to a
problem I'm having - I'm sure this has been done before but haven't found
anything in the archives.
Basically the problem I am having is how best to handle multiple values for
a specific column, in this cas
13 matches
Mail list logo