Categories
Sponsors
Archive
Blogroll
Badges
Community
|
Posted in Hosting & IIS7, Windows Powershell, Windows Server | No Comment | 4,195 views | 23/06/2009 10:13
You can remove MySQL user 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()
# Drop MySQL User
$dropmysqluser = "DROP USER '" + $dbusername + "'@'localhost'"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($dropmysqluser, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds) |
# 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()
# Drop MySQL User
$dropmysqluser = "DROP USER '" + $dbusername + "'@'localhost'"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($dropmysqluser, $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.
Posted in Hosting & IIS7, Windows Powershell, Windows Server | 1 Comment | 5,648 views | 23/06/2009 10:07
You can remove MySQL 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()
# Drop MySQL Database
$dropmysqldatabase = 'DROP DATABASE `' + $dbname + '`'
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($dropmysqldatabase, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds) |
# 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()
# Drop MySQL Database
$dropmysqldatabase = 'DROP DATABASE `' + $dbname + '`'
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($dropmysqldatabase, $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.
Posted in Hosting & IIS7, Windows Powershell, Windows Server | No Comment | 2,816 views | 23/06/2009 10:01
You can flush MySQL privileges 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()
# Flush Privileges
$flushprivileges = 'FLUSH PRIVILEGES'
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($flushprivileges, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds) |
# 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()
# Flush Privileges
$flushprivileges = 'FLUSH PRIVILEGES'
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($flushprivileges, $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.
Posted in Hosting & IIS7, Windows Powershell, Windows Server | No Comment | 4,024 views | 23/06/2009 02:50
You can change or set MySQL user password 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()
# Set MySQL User Password
$setmysqlpassword = "SET PASSWORD FOR '" + $dbusername + "'@'localhost' = PASSWORD('" + $dbpassword + "')"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($setmysqlpassword, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds) |
# 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()
# Set MySQL User Password
$setmysqlpassword = "SET PASSWORD FOR '" + $dbusername + "'@'localhost' = PASSWORD('" + $dbpassword + "')"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($setmysqlpassword, $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.
Posted in Hosting & IIS7, Windows Powershell, Windows Server | No Comment | 3,705 views | 23/06/2009 01:43
You can create MySQL user 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()
# Create MySQL User
$createmysqluser = "CREATE USER '" + $dbusername + "'@'localhost'"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($createmysqluser, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds) |
# 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()
# Create MySQL User
$createmysqluser = "CREATE USER '" + $dbusername + "'@'localhost'"
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($createmysqluser, $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.
Posted in Hosting & IIS7, Windows Powershell, Windows Server | No Comment | 4,149 views | 23/06/2009 01:39
You can create MySQL 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()
# Create MySQL Database
$createmysqldatabase = 'CREATE DATABASE `' + $dbname + '`'
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($createmysqldatabase, $conn)
$da = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($cmd)
$ds = New-Object System.Data.DataSet
$da.Fill($ds) |
# 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()
# Create MySQL Database
$createmysqldatabase = 'CREATE DATABASE `' + $dbname + '`'
$cmd = New-Object MySql.Data.MySqlClient.MySqlCommand($createmysqldatabase, $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.
|