sonesay 7 Report post Posted February 17, 2008 Hi all, I can't seem to create a new database, I thought we have unlimited databases in mysql with our free hosting, If I'm wrong then disregard this. I have only 1 database created on my account and I need another as using the same one would be conflicts with my naming convention.Anyone have any idea why? # Create new database: DocumentationNo Privileges Share this post Link to post Share on other sites
gameratheart 0 Report post Posted February 17, 2008 (edited) Hi all, I can't seem to create a new database, I thought we have unlimited databases in mysql with our free hosting, If I'm wrong then disregard this. I have only 1 database created on my account and I need another as using the same one would be conflicts with my naming convention.Anyone have any idea why?For some reason, phpMyAdmin is unable to create new databases. Instead you must use the Database Manager. On the main menu on the Cpanel, next to the "phpMyAdmin" icon, there's an option for "MySQL Databases". You can create new databases, add new users and set their permissions, and set the Access Hosts there. Hope that helps!Oh, and for the record, each Xisto web hosting account has a limit of 99 MySQL Databases. This limit is due to the CPanel not allowing the "infinite" setting for MySQL Databases. But I don't think anybody needs to create 99 Databases, anyway Edited February 17, 2008 by gameratheart (see edit history) Share this post Link to post Share on other sites
nol 0 Report post Posted February 17, 2008 ya, also, even though you create a database from mysql databases, you can still edit and fix databases through phpMyAdmin Share this post Link to post Share on other sites
jlhaslip 4 Report post Posted February 17, 2008 The above Replies are exactly correct. It is typical of a Hosting Server that MySQL Databases be used to Create the Database and Users. Then you use phpMyAdmin to create the Tables, Manage the Data Records, etc.MySql and phpMyAdmin in a Hosting environment are different than the copy on your Localhost machine. Locally, you can use phpMyAdmin to do all of that, but not on a typical shared hosting Server. Too risky. It is actually a Security of data issue. And it in no way limits your access to or number of Databases available.Hope this answers your questions. Share this post Link to post Share on other sites
sonesay 7 Report post Posted February 17, 2008 thanks for all your replies I'm set now. Share this post Link to post Share on other sites
rvalkass 5 Report post Posted February 17, 2008 Topic is resolved.Please PM any moderator to continue this discussion. Until then, this topic is closed. Share this post Link to post Share on other sites
