Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-04-28, 10:57:21

Author Topic: [PROPOSE] MySQL database name and their username  (Read 2971 times)

0 Members and 1 Guest are viewing this topic.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
[PROPOSE] MySQL database name and their username
« on: 2014-02-16, 08:51:10 »
At this moment, mysql database name no more then 16 chars with format AAA_BBB (AAA = client name and no more than 12 chars; BBB = additional chars; no more than 3 chars). Database username is the same same as database name (if dataname is tester_wp and username is tester_wp too).

The fact related to mysql naming:
1. database name possible UNTIL 64 chars
2. database username limiting to 16 chars

Propose for mysql database name and username:
1. Database name possible until 64 chars ( lowercase alphanumeric and '_') with format CCC_BBB (CCC = 4 chars for random lowercase alphanumeric; example: a1sd; BBB = lowercase alphanumeric; example: wordpress or wp123)
2. Database username as the same as client name -> all databases under 'tester' client always using 'tester' database username.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline chrisf

  • Senior Master
  • **
  • Posts: 883
  • Karma: +11/-1
  • Gender: Male
  • Be the change that you wish to see in the world.
    • View Profile
    • Conviction's Hosting
Re: [PROPOSE] MySQL database name and their username
« Reply #1 on: 2014-02-16, 15:48:26 »
+1 for this.  MySql username should always be client name

Very good proposal.
« Last Edit: 2014-02-16, 15:50:08 by chrisf »
Christopher

Knowledge in: PHP, Perl, MySQL, Javascript, Actionscript, FLASH, HTML, CSS
Server Administrator / Developer: https://convictionshosting.com

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.057 seconds with 18 queries.

web stats analysis