> simrad_4# safe_mysqld --skip-grant-tables &
> [1] 57953
> simrad_4# Starting mysqld daemon with databases from /var/db/mysql
> simrad_4# mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.23.38
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
> mysql> grant all privileges on *.* to root@localhost identified by 'xxxxxx';
> ERROR 1047: Unknown command
bonjour,
I get this error once. My root was'nt really root so couldn't use
GRANT command. That is the same for a bash command you're not allowed to use
as normal user.
You need add a root password:
[shell]mysql -u root mysql
mysql> update user set Password=password('xxxxx') wher User='root';
jean-michel
---------------------------------------------------------------------
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php