指定mysql ruby连接中的端口

require 'mysql'

# 创建MySQL连接
client = Mysql.new('localhost', 'username', 'password', 'database', port)

# 执行查询
result = client.query('SELECT * FROM table')

# 处理查询结果
result.each do |row|
  puts row
end

# 关闭连接
client.close

require 'mysql2'

# 创建MySQL连接
client = Mysql2::Client.new(host: 'localhost', username: 'username', password: 'password', database: 'database', port: port)

# 执行查询
result = client.query('SELECT * FROM table')

# 处理查询结果
result.each do |row|
  puts row
end

# 关闭连接
client.close