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-27, 23:21:23
« previous next »
Pages: [1]   Go Down

Author Topic: Unable to login to database containing "-" or "."  (Read 2930 times)

0 Members and 1 Guest are viewing this topic.

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Unable to login to database containing "-" or "."
« on: 2014-02-14, 18:17:07 »
How to reproduce:

Create database like this:

user-mydatabase

or

user-mydatabase.test

then try to login to phpMyAdmin by clicking the black dot near database name.

You will get message unable to login to MySQL server.

That's why we need to block - and . inside database names !
Logged

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: Unable to login to database containing "-" or "."
« Reply #1 on: 2014-02-14, 20:48:49 »
+1.  A simple regex alphanumeric check would work, allowing a-z, 0-9 but no other characters.
Logged
Christopher

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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Unable to login to database containing "-" or "."
« Reply #2 on: 2014-02-15, 03:50:14 »
As I know, mysql database name only with alphanumeric plus _ (underline) and . (dot).
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: Unable to login to database containing "-" or "."
« Reply #3 on: 2014-02-17, 14:26:55 »
Yes, but customers are able to create such databases inside Kloxo and then they are reporting they cannot login. People are dumb you know ;)
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Unable to login to database containing "-" or "."
« Reply #4 on: 2014-02-17, 14:47:55 »
Next release of 6.5.1.a will include validate for client name, database and password entry.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --
Pages: [1]   Go Up
« previous next »
 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.079 seconds with 18 queries.

web stats analysis