Create DataBase pro...
 
Notifications
Clear all

Create DataBase problem (MySQL)

7 Posts
2 Users
0 Reactions
1,136 Views
Posts: 36
Topic starter
(@ndricim)
Eminent Member
Joined: 9 years ago

Hi guys, I can't create a mysql databse i receive this error

 

Page URL:
http://cp2.veselaj.com/Default.aspx?pid=SpaceMySql5&mid=152&ctl=edit_item&SpaceID=10

Logged User:
ndricim

Work on Behalf:
ndricim

Hosting Space:
10

Stack Trace:
System.Exception: Exception of type 'System.Exception' was thrown.

6 Replies
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Hello,

For mysql make sure you have the mysql connector installed (any version), aswell as the login information correctly set in the  configuration --> servers --> mysql service.

(do note mysql has many aspects including strikt mode, and login depending on hostname or wildcard %)

Once their properly set it should create without issues.

Regards,

Marco

Reply
Posts: 36
Topic starter
(@ndricim)
Eminent Member
Joined: 9 years ago

I have mysql connector

When i create a mysql user from solidcp it create without a problem, the problem is only with databases

Reply
2 Replies
Admin
(@m-tiggelaar)
Joined: 9 years ago

Noble Member
Posts: 1995

Alright, then are you creating db's with a specific (long) name or symbols like - in there?

Reply
(@ndricim)
Joined: 9 years ago

Eminent Member
Posts: 36

i solve that, the problem was on my config file, but i have the same problem with MSSQL

Reply
Posts: 36
Topic starter
(@ndricim)
Eminent Member
Joined: 9 years ago

no its not a long name but it has a prefix "3_" also the username has the prefix

Reply
1 Reply
Admin
(@m-tiggelaar)
Joined: 9 years ago

Noble Member
Posts: 1995

Prefix shouldn't cause any issues normaly.
the database name your trying to create also confirmed not to exist in mysql etc?
as we never really had any issues with mysql or maria, on any of our servers i would suspect configurational values

Reply
Share: