Ruby connects to the MySQL database in Linux

To access an existing database, you must create a MySQL superuser account in Ruby.

The solution is as follows:

MySQL defines a method, creates a pipeline to connect to the MySql client, and outputs SQL statements.

DefMysql (opts, stream) IO. Popen ("Mysql # {opts }",'W') {| Io. puts stream} End

You can use the following code to create, delete, and manage a MySql database:

Mysql'-U root-p [password]', <-End Drop databaseIfExists website_db; Create database website_db; Grant all on website_db. *# {'Id-UN'. strip} @ localhost; End