Setting Up MySQL Databases for New Websites: Difference between revisions

From Littledamien Wiki
Jump to navigation Jump to search
No edit summary
Tag: wikieditor
No edit summary
Tag: wikieditor
 
Line 1: Line 1:
See [[Creating New MariaDB Databases]]
== Workflow ==
== Workflow ==


Line 21: Line 23:
*** Click '''Stop Service'''
*** Click '''Stop Service'''
*** Click '''Start Service'''
*** Click '''Start Service'''
== TODO ==
Research creating a script to create new databases for websites.
<syntaxhighlight lang="mysql">
# log in
shell> mysql -h {host} -u root
# create the database
mysql> CREATE DATABASE {database_name};
# create the user
# grant user privileges on the database
</syntaxhighlight>


[[Category:MySQL]][[Category:MariaDB]][[Category:Databases]][[Category:Web Development]]
[[Category:MySQL]][[Category:MariaDB]][[Category:Databases]][[Category:Web Development]]

Latest revision as of 13:48, 5 March 2024

See Creating New MariaDB Databases

Workflow[edit]

  • Remote Desktop to the development web server
  • MySQL Administrator
    • Login as "root"
    • Catalogs > schema list > right click > Create New Schema (Ctrl+n)
    • User Administration > user list > right click > Add new user
      • User Information tab
        • Enter login
        • Generate password using cPanel's MySQL administration
          • Login to cPanel
          • Databases > MySQL Databases
          • MySQL Users > Password Generator > copy the password string
          • Save the password in the site configuration
          • Enter the password in MySQL Administrator
      • Schema Privileges tab
        • Select the new database from the Schemata list
        • Click the << button to move all Available Privileges to the Assigned Privileges column.
      • Click Apply changes
    • Service Control
      • Click Stop Service
      • Click Start Service
Retrieved from "https://wiki.dbarchowsky.com/index.php?title=Setting_Up_MySQL_Databases_for_New_Websites&oldid=3614"