人工大脑

本页面只读。您可以查看源文件，但不能更改它。如果您觉得这是系统错误，请联系管理员。

====== MySQL 创建数据库 ======

<code sql>
CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'myuser'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'mypassword';
GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'myuser'@'%';
FLUSH PRIVILEGES;
</code>

<html>
<form onsubmit="generate(event)">
<div><input id="inputDatabase" name="database" value="database"></div>
<div><input id="inputUsername" name="username" value="username"></div>
<div><input id="inputPassword" name="password" value="password" autocomplete="off"></div>
<div><button type="submit">生成</button></div>
<div><textarea id="outputSQL" rows="5" style="width: 100%;"></textarea></div>
</form>
<script>
function generate(event) {
event.preventDefault();
var template = document.querySelector('pre.code.sql').textContent;
var result = template.replaceAll('mydatabase', inputDatabase.value)
  .replaceAll('myuser', inputUsername.value)
  .replaceAll('mypassword', inputPassword.value);
outputSQL.value = result;
}
</script>
</html>

{{tag>mysql}}