xunIQ
May 15 2005, 05:53 PM
| | Hi, everyone
I'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? |
Comment/Reply (w/o sign-up)
vhortex
May 16 2005, 03:08 AM
QUOTE (xunIQ @ May 16 2005, 03:59 AM) Did you realy read my post? 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.. 
Comment/Reply (w/o sign-up)
KickitREAL
May 17 2005, 02:48 AM
QUOTE (vhortex @ May 16 2005, 03:08 AM) 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.. Thganks for th info vortex!!!!!!!!!!!!!
Comment/Reply (w/o sign-up)
vhortex
May 18 2005, 12:49 PM
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.. 
Comment/Reply (w/o sign-up)
Samya
Mar 20 2006, 07:20 PM
Ohhh ... if ur Web Host doesnot have cPanel ... than I think that u can create it using PHP itself .... SQL Query through PHPmyAdminJust 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 : QUOTE CREATE DATABASE `samya` ; Thats it ... u are done .... Using PHPThis is more or less similar to First method ... Use this Code : QUOTE 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 : QUOTE <?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 $dbpassThe value $dbhost is ur Host. In more than 85% cases it is either : 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 : QUOTE $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
Comment/Reply (w/o sign-up)
AVEX
May 7 2006, 05:38 AM
Hi my name is ronald I 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
Comment/Reply (w/o sign-up)
ewwink
May 10 2006, 07:34 PM
vhortex
May 19 2006, 06:35 PM
QUOTE(AVEX @ May 7 2006, 01:38 PM) 
Hi my name is ronald
I 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 table as 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 to the 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
Comment/Reply (w/o sign-up)
xmatihasx
Jun 25 2006, 05:16 PM
you must put PHPmyadmin and soon to put to create new database and within her you create the table
Comment/Reply (w/o sign-up)
Gamemaster
Jul 28 2006, 12:33 PM
 go to www.freeforum101.com 
Comment/Reply (w/o sign-up)
khalilovitch
Jun 19 2007, 01:47 PM
QUOTE(Gamemaster @ Jul 28 2006, 03:33 PM) go to www.freeforum101.com ITs giving me blank O_o
Comment/Reply (w/o sign-up)
LeafH
Apr 2 2007, 02:34 PM
QUOTE(Gamemaster @ Jul 28 2006, 08:33 PM) go to www.freeforum101.com 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!!
Comment/Reply (w/o sign-up)
minnieadkins
Aug 29 2006, 03:42 PM
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.
Comment/Reply (w/o sign-up)
Vyoma
Aug 22 2006, 06:35 AM
QUOTE(webintern @ Aug 22 2006, 07:27 AM)
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.
Comment/Reply (w/o sign-up)
webintern
Aug 22 2006, 01:57 AM
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.
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : creating, mysql, db
- Login System
I want to make a login system using Mysql. I am amateur in these thing (12)
Mysql Overhead
(3) Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
Mysql Multiple Tables
(3) It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
all of the rows in the table. Normally you will try to not select the entire table from the database
unless you absolutely want all of the table. I would recommend against it; just gra....
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Mysql Database Entry By Excel Sheets
(3) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE $host = 'CENSORED'; // my host $host =
'righto'; // my database username $host = 'CENSORED'; // my database
password $host = 'odinms'; // my datab....
Mysql Backup With Another Address?
(4) I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
here at astahost, can I restore those backups? Is the change of the site address going to interfere
with this? Is there anyway I can edit those databases to work with my new address? Please help me
out here!....
Sun Bought Mysql
(6) SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company,
they did it to come in to the database market, is it a good reson to buy it?....
Mysql - So Hard
Come in here if you think MySQL is soo hard! (14) Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
databases just for one little script and you have to type things in like ;Host-Username:
(blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
random, and it is alot harder than that. If you have expierenced it being hard, you are free to
post right in here, mate.....
Subqueries In Mysql
Using subqueries in MySQL. Very helpful. (2) This method is very useful. I always use this when simple queries of linking two tables is not
enough. This method is putting a query inside a query. Example: SELECT * FROM table1 LEFT JOIN
(SELECT * FROM table2 WHERE field1='id') AS subtable or joining multiple queries SELECT *
FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2
WHERE field1='id') AS subtable2 You can join more than two queries depending on the output
you want. If someone already posted this topic here I'm sorry I don't know.....
Mysql Query Question
MySQL Select query problem (4) Hii Guyz, I am having this little problem creating a query in MySQL. Problem description: Table:
mytable Table Structure: IssueId | ToolName | Status 01 | Tool1 | Open 02 | Tool1 | Closed 03 |
Tool2 | Closed 04 | Tool3 | Open Now, I want to get the results in the following form: ToolName |
Count(Open) | Count(Closed) For the above input, result will be: Tool1 | 1 | 1 Tool2 | 0 | 1 Tool3
| 1 | 0 There should be NO duplicate toolName in output. Thnaks, Manu.....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....
Mysql And Php
When trying to install Joomla (16) I don't know if this is the correct forum, but here is my question: I'm trying to test
Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
Yes - zlib compression support Available - XML support Available - MySQL support
Unavailable configuration.php Writeable Session save path Unwriteable Not ....
Navcat For MySQL
is Navcat any good? (9) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
(6) Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
MySQL, Multiple Tables
(27) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
MySQL Output Database Question
(19) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
MS-database To MySQL
I'd like to batch them (6) Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
control the output of the Windows-thing (so I can't export them to a *csv or something), I can
write an import script. But since I'm not that great with Regular Expressions and don't know
anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
out the field information and put it in arrays or something more readable. It wou....
What Are The Alternatives To MySQL
(7) Hi. i'm interested in alternatives to MySql combined with php. what database else can i use to
create a webbased managment system with a lot of entries. maybe more than mysql can handle fast
enough. it should be more powerful than mysql and should have nearly the same features. i hope
there is a webbased administration program like phpmysqladmin thanks for your help ! greetings c.....
Mirror My MySQL Database To Another Mysql Server
(7) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Recover Tables From A MySQL .frm File
(9) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL Database Problems
(10) My friends have a little forum running here . The problem is that quite often we get the following
message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/vhosts/roh....
Error In Installing MySQL Server
MySQL server cannot be started (10) I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
essential one) for win XP Then I install the new version after the old version was uninstalled.
After the installation process, Instance Configurator comes up to help for the configuration. But an
error occured when it try to start the MySQL service. Error messageis "cannot create windows
service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
How Can I Import Csv Files To My MySQL Database?
I was able to export but where's import? (7) I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
can I import csv files in mysql server?....
MySQL Datetime --> VB.NET Datetime Conversion Prob
Any solutions ?? (4) Hi, Can anyone provide me with a quick example of fetching a MySQL Datetime Field and converting it
into native VB.NET DateTime format ?? Say for example my db contains a couple of fields: Field1,
Field2, DateField... one of which is the default MySQL DateTime. Say I'm using the following
code to connect... CODE ConnectionString = "....." QueryString = "SELECT * FROM SomeTable" Dim
myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString) Dim myCommand As New
MySql.Data.MySqlClient.MySqlCommand(QueryString, myConnection) Dim myReader As MySq....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for creating, mysql, db
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for creating, mysql, db
|
advertisement
|
|
