error creating db and user
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Easy Hosting Control Panel for Ubuntu |
Confirmed
|
Wishlist
|
Unassigned | ||
Bug Description
When creating db and user for local test site my1domail.net, and putting username: my1domail.net; password: my1domail.net
= Getting error Error Occured (source:Error creating db (executequery: create database my1domain.net DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.net DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci' at line 1))err:
Some Error Occured.
Error creating db.. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.net DEFAULT CHARACTER SET utf8 COLLATE utf8_turkish_ci' at line 1
Shoud it eat just any chars?
May be problem is in utf8_turkish_ci?
Why not utf8_general_ci?
| ehcpdeveloper (ehcpdeveloper) wrote | #1 |
| Changed in ehcp: | |
| importance: | Undecided → Wishlist |
| status: | New → Confirmed |
dot cannot be used in db name in this way. dbname is not accepted by mysql.
Anybody knows howto use dot in db names in mysql ?
this seems a mysql behaviour.