MySQL Configuration

Set up the MySQL database for your Drupal site.

MySQL configuration

....my.cnf parameters for InnoDB...

Database Setup
Create the Drupal database:

/usr/local/mysql/bin/mysqladmin -u <username> -p create <databasename>

Log into MySQL:

/usr/local/mysql/bin/mysql -u <username> -p

Create a user and grant it the appropriate privileges for your database:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, INDEX, CREATE
TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Recent Updates

  • Apache
    1 year 12 months ago
  • Apache
    1 year 12 months ago
  • lighttpd
    1 year 12 months ago
    php 8.x
  • MariaDB
    1 year 12 months ago
    10.6.7
  • CentOS
    2 years 18 hours ago
    Drop Centos 5/6 stuff