How to remove MySQL user with Powershell?
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) |
Also I used arguments so you can call this powershell script from your panel.
Tags: drop mysql user powershell, powershell drop user mysql, powershell mysql connector, remove mysql user powershell
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Leave a Reply