search
Categories
Sponsors
VirtualMetric Hyper-V Monitoring, Hyper-V Reporting
Archive
Blogroll

Badges
MCSE
Community

Cozumpark Bilisim Portali
Posted in Hosting & IIS7, Windows Powershell, Windows Server | No Comment | 2,351 views | 23/06/2009 02:55

You can grant MySQL User on database from Powershell with MySQL connector:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
# Powershell Args
$dbusername = $args[0]			# user01073
$dbpassword = $args[1]			# RadoreTelekom
$dbname = $args[2]     			# db01073
 
# Add MySQL Data Connector
[void][system.reflection.Assembly]::LoadWithPartialName("MySql.Data")
 
# Open Connection to SQL Server
$connStr = "server=127.0.0.1;port=3306;uid=root;pwd=SQLPassword"
$conn = New-Object MySql.Data.MySqlClient.MySqlConnection($connStr)
$conn.Open()
 
# Grant MySQL User on DB
$grantmysqluser = 'GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,REFERENCES ON ' + $dbname + '.* TO `' + $dbusername + '`@`localhost` WITH GRANT OPTION' 
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($grantmysqluser, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds)

Also I used arguments so you can call this powershell script from your panel.