mysql.md

MySQL

Description

MySQL is an open-source relational database management system (RDBMS) widely used for web applications and data-driven solutions. Known for its speed, reliability, and ease of use, MySQL supports SQL for querying and managing data. With broad community support and compatibility across platforms, it is a popular choice for small projects, large-scale applications, and enterprise environments.

---

Index

• Default
  • Port : 3306
  • User : root
  • Database : sys
• Download
  • Installer : win-8.0.40-web win-8.0.40-full
  • Workbench : win-8.0.40-full
• Example
  • Column
  • Database
  • Function
  • Procedure
  • Table
  • User
  • View

---

Example

User

• Create

CREATE USER 'debug'@'%' IDENTIFIED BY 'ABcd!@34';
GRANT ALL PRIVILEGES ON *.* TO 'debug'@'%';
FLUSH PRIVILEGES;

• Delete

REVOKE ALL PRIVILEGES ON *.* FROM 'debug'@'%';
DROP USER 'debug'@'%';
FLUSH PRIVILEGES;

• Password

ALTER USER 'username'@'%' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;