mysql> use mysql;
mysql> update user set grant_priv = 'Y' where user = 'root';
mysql> flush privileges
and reconnect to mysql server as root user and
retry grant clause. You'll be happy!!! ^^
> Greetings,
>
> I'm trying to create a database and then adding a
> specialized user so it can work wit
If you use PHP
program like below...
It's simple
OK ?
if you use other programming language, It's similar to above example.
Sorry, My english is so poor -_-;;
> Is it possible to rename a MySQL table? If so, how?
> If not, is there a simple query syntax to copy a table?
> I don't have access
RENAME TABLE tbl_name TO new_tbl_name[, tbl_name2 TO new_tbl_name2,...]
you can find it from MYSQL MANUAL section RENAME TABLE SYNTAX
> (I tried to post this once, but it didn't show up - sorry if
> this is a duplicate!)
> Can you rename a table? If so, how?
> If not, is there an easy query to ru
