[help] Sql

[mager1794]

USE `mysql;
SELECT COUNT * FROM `user`;
SHOW TABLES LIKE 'user';
SHOW COLUMNS FROM `user` LIKE '%';
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED by '123456789';
FLUSH PRIVILEGES;


isn't this the SQL command to create a new user on it??

if not does anyone know it??

[2dgreengiant]

If you can connect to your database you can make users easily in SQLyog or NAvicat much easier.

[waymirec]

That is, essentially, it. To add a user and give them access to a db all you have to do is:

GRANT ALL ON dbname.* TO 'user'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Ofcourse if you can you're better off replacing % with their hostname or ip.