SQL Permissions

NZ_Kiwis

Does anyone know how I can change these via a php script???

bradgrafelman

Same way as the CLI or the commands that GUIs such as phpMyAdmin do it; query the MySQL database using the GRANT, REVOKE, etc. privileges.

NZ_Kiwis

Can someone please explain how I rund these from a PHP script. I've never seen this type of code before.

thanks

bradgrafelman

$query = "GRANT ALL ON *.* TO 'username'@'host' IDENTIFIED BY PASSWORD 'mypass'";
$exec = mysql_query($query) or die('MySQL Error - ' mysql_error());

Functions used: [man]mysql_query/man, [man]die/man, [man]mysql_error/man.

NZ_Kiwis

I have this code with this error... what am i doing wrong??

Parse error: parse error, unexpected T_STRING in /home/rlnz/public_html/folder/ip.php on line 6

$hostname = gethostbyaddr($_SERVER['REMOTE_ADDR']);

$query = "GRANT ALL ON *.* TO 'myusername'@'$hostname' IDENTIFIED BY PASSWORD 'password'"; 

$exec = mysql_query($query) or die('MySQL Error - ' mysql_error());

mjax

Change this line:

$exec = mysql_query($query) or die('MySQL Error - ' . mysql_error());

You forgot the . (dot) operator.

NZ_Kiwis

Oh yeah missed that, what's this about then??

MySQL Error - Password hash should be a 41-digit hexadecimal number

mjax

You are probably running a 4.1 MySQL server (or higher) which uses a new password scheme. Your PHP proably uses a old client library.

See http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html for more information about this.

NZ_Kiwis

Wow i'm lost.... help me

NZ_Kiwis

$exec = mysql_query("GRANT ALL ON *.* TO 'folder'@'$hostname'") or die('MySQL Error - ' . mysql_error());

This works fine, how can I set a password with this??

bradgrafelman

Just add the IDENTIFIED BY clause...

mysql> GRANT ALL ON *.* TO 'folder'@'hostname' IDENTIFIED BY 'mypass';
Query OK, 0 rows affected (0.09 sec)