How to create MySQL database with Powershell?
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) |
Also I used arguments so you can call this powershell script from your panel.
Tags: create mysql cmd, create mysql database with powershell, create mysql powershell, mysql connector, powershell mysql connector, powershell mysql database
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