MySQL Questions

I am new to your hosting. In trying to create a new database, I have run into two significant show stoppers. First, I can't create any views in my database. Is this a limitation of your MySQL configuration or am I'm doing something wrong? I'm 100% the syntax is correct. Second, my application needs to be able to support database transactions and have referential integrity maintained (which seems to be unsupported with MyIsam engine). How can I do this in your MySQL servers. I've tried to create my tables with Innodb engine, but it never seems to work. Please enlighten me.

Thanks

What is your mysql username, domain, and database you need Create View perms on?

The database names are pppgwb07_pppgwebdev and pppgwb07_pppgwebdev and the user is pppgwb07_pppgdb2. The domain is www.pikespeakpokergang.org. The bigger issue is the database engine problem, though.

I am off-shift right now, but I will let one of my colleagues know to:

mysql

> use mysql;
> UPDATE user SET Create_view_priv='Y' WHERE user='pppgwb07_pppgdb2';

Thanks. What about being able to enforce referential integrity and using transactions. I need to be able to create my tables with the INNODB engine??

[mlinleysr]

i have a queston also. i am brand new to this and need to set up my sql database. what do i put into the various fields. i really do not know what to call it or where to store it? would appreciate any advice. and i have watched the videos.

[mlinleysr]

under the my sql database wizard it already puts in your username _
and then i guess you are supposed to put in a folder name or something. how about the web address of the thing you are trying to save?

[Pazeh]

milinleysr, first welcome to the peer support forum of HG.
Second, tho your problem looks likes the problem of the OP (thread starter), it will be way better if you can open your own thread specially if the thread is about 1,5 yr old.

As for your problem, you can put anyname for the db, user & password; but note the folowing.
- Always prefix your cpanel username to the db (database) user & db name. example, if you created a username DbUsername, your actual username will be YourCpanelUsername_DbUsername, this is true for the DbName too

- You have to assign the user to the db to work.
- There is no folder name, but there is server address which is localhost (the same server) or if you are required to put an IP its 127.0.0.1

hope these help