xunIQ 0 Report post Posted May 15, 2005 Hi, everyoneI've host and I want to upload phpbb2 but there isn't a cpanel and I know I must create a mysql db how can I do?Did you realy read my post? Share this post Link to post Share on other sites
vhortex 1 Report post Posted May 16, 2005 Did you realy read my post? <{POST_SNAPBACK}> the only way to do that is to ask the host admin itself to create the database for you. if you already have a username and password for the mysql connection and it have access to create new databases, then just use any other 3rd party mysql database administration software and a webversion of it is phpmyadmin.. some host just give you one database and they mostly have the same name as the web domain that you have.. Share this post Link to post Share on other sites
KickitREAL 0 Report post Posted May 17, 2005 the only way to do that is to ask the host admin itself to create the database for you. if you already have a username and password for the mysql connection and it have access to create new databases, then just use any other 3rd party mysql database administration software and a webversion of it is phpmyadmin.. some host just give you one database and they mostly have the same name as the web domain that you have.. <{POST_SNAPBACK}> Thganks for th info vortex!!!!!!!!!!!!! Share this post Link to post Share on other sites
vhortex 1 Report post Posted May 18, 2005 no problem, a tick in my reputation point will encourage me to participate more..just feel free to ask here in the board coz i am lurking this specific forum for databases and i will surely answer every question that i have knowledge of.. Share this post Link to post Share on other sites
Samya 0 Report post Posted March 20, 2006 Ohhh ... if ur Web Host doesnot have cPanel ... than I think that u can create it using PHP itself .... SQL Query through PHPmyAdmin Just go to PHPmyAdmin and u can create a new Database either my using the GUI Interface or u can insert the MySQL query .. If u want to insert the SQL Query than, I am assuming that u want to make a database named samya. Than here is ur Query : CREATE DATABASE `samya` ; Thats it ... u are done .... Using PHP This is more or less similar to First method ... Use this Code : mysql_create_db('samya'); Keep one thing in mind that before calling for this function, u must have already connected with the Database ... U can can connect with the database using this function : <?php $dbhost = 'localhost'; $dbuser = 'username'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); ?> Place ur Databse username and Password into $dbuser and $dbpass The value $dbhost is ur Host. In more than 85% cases it is either : localhost127.0.0.1 However u may have a different value. Contact ur Hosting Provider for this purpose ..If u know the MySQL server name and port number than u can insert this into $dbhost. For example if the MySQL server name is db2.mydomain.com and the Port number is 3306 (it is also the default port number for MySQL) then you you can modify the above code to : $dbhost = 'db2.mydomain.com:3306'; Please note that u must have given the relevant permissions to the user before u can do all these ... Otherwise, u gonna receive the error of Access Denied or No Priveleges **** All Appreciations and Criticisms and Appreciations are welcome **** Regards: Samya Khalid Share this post Link to post Share on other sites
Avex1983 0 Report post Posted May 7, 2006 Hi my name is ronaldI would ask something i have made my personel computer as testserver.But my pc cant make connection to administrator password login my pc connects to the database and shows all tabels perfect but admin tabel he cant see. I thought it was the session. But i dont know it for sure Who can help me Contact me at Ronaldavex21_AT_hotmail_DOT_com Share this post Link to post Share on other sites
ewwink 0 Report post Posted May 10, 2006 i'll trty it Share this post Link to post Share on other sites
vhortex 1 Report post Posted May 19, 2006 Hi my name is ronaldI would ask something i have made my personel computer as testserver.But my pc cant make connection to administrator password login my pc connects to the database and shows all tabels perfect but admin tabel he cant see. I thought it was the session. But i dont know it for sure Who can help me Contact me at Ronaldavex21_AT_hotmail_DOT_com did you check the ownership or access rights for the said table?if you dont have a view access or list access rights to that table. the table wont appear..this gives me hell of a nightmare when i have accidentally set the owner of the tableas default [in my setup of mySQL on fedora core4, default is user nobody]to make worst about the settings, i have ticked that only user default have access tothe database table and all will be deny.so my account that i use to connect and share to my friends cant see the table..--try SQLYOG at webyog.com to see a visual GUI of who / or what access rights you have given to other mySQL accounts for that table./hope i help Share this post Link to post Share on other sites
iGuest 3 Report post Posted June 25, 2006 you must put PHPmyadmin and soon to put to create new database and within her you create the table Share this post Link to post Share on other sites
Tornado4u 0 Report post Posted July 28, 2006 go to http://forums.xisto.com/no_longer_exists/ Share this post Link to post Share on other sites
pyost 0 Report post Posted July 28, 2006 go to http://forums.xisto.com/no_longer_exists/ And you are replying to what? The creator of the thread didn't need a free forum, he just needed a few pointers on how to install one on his server. Not to mention that this service is very unprofessional. I've already seen this template, which means it is free. Anyone who is doing some serious business should have a unique template. Share this post Link to post Share on other sites
webintern 0 Report post Posted August 22, 2006 I apologize ahead of time if I'm asking a redundant question that was already answered above.Anyway, is there a way to upload onto AwardSpace a MySQL database that was made offline on my own computer? Or, do I have to go through PHPMyAdmin and redo the entire database structure and repopulate the fields?I don't have a host account yet, but am considering getting one in the future. Thank you in advance for your help. Share this post Link to post Share on other sites
Vyoma 0 Report post Posted August 22, 2006 I apologize ahead of time if I'm asking a redundant question that was already answered above.Anyway, is there a way to upload onto AwardSpace a MySQL database that was made offline on my own computer? Or, do I have to go through PHPMyAdmin and redo the entire database structure and repopulate the fields?I don't have a host account yet, but am considering getting one in the future. Thank you in advance for your help. I think that should be possible. Export the database you created on your personal computer onto a file - you may enable gzip if the file is large. Then, you need to connect to your AwardSpace account, get into the phpMyAdmin and then there is an option to import. Select it and select the file you have exported and see that you check options identical to that when you exported for compatibilty.Using the above method, I have been able to setup database on my personal computer qutie similar to my website database. I know your case is the otherway round, but I do not see why the same solution cannot be used. Share this post Link to post Share on other sites
minnieadkins 0 Report post Posted August 29, 2006 (edited) As he said, just go to phpmyadmin and export the SQL to create the database for you. That's all you need to do. Then copy and paste the sql or import it into a SQL window to create your database on your new server. If you have shell access you could possibly also run the sql directly from the command line.If you have any questions about how to do this feel free to ask. I'm sure someone will gladly help you. Although if you do a quick google for help in phpmysql I'm sure you won't find it very difficult. Edited August 29, 2006 by minnieadkins (see edit history) Share this post Link to post Share on other sites
LeafH 0 Report post Posted April 2, 2007 go to http://forums.xisto.com/no_longer_exists/ 1. Log in CPanel 2. find the database manager to creat a new database. normally, if your login username is AREO then your MySQL Database Name/Username would be like "AREO_XXXXXX" PS:Sometimes you can do it on phpmyadmin ~ it depends on your hosting. 3. you need to set up a password for your new database like"AREO_XXXXXX" Note: you need to find out your db host (ie: wall.space.com, pls check your host provider) the creatiing mysql db completed!! Share this post Link to post Share on other sites