Create Database Outside From The MySql?
It is possible for me to create database outside from the MySql root folder?
View Complete Forum Thread with Replies
Related Forum Messages:
Create Database Mysql Database In My System
I have installed MySQL 4.1.7-Standard in MacOS X (10.3.5). I have ONLY database test. According to the manual there should be TWO. test and mysql. I have re-run mysql_install_db several times with he same result. Can some mysql guru explain or point me to the right page to have this mysql database in my system?
View Replies !
Mysql Database Create
All i want to do is create a page with a response form, e.g. name etc and some radio buttons (part of a uni project, but i'm a chemist!) and a submit button to save the data in a database. I installed iss microsoft web server and php and the mysql database. Php works fine, i could write to a text file, and using phpinfo(); it says everythings ok and a mysql section is there, so i'm guessing mysql is installed ok. The php script to insert info etc in to databases seems easy enough, but i have no idea how to create a database! I searched everywhere, but could find nothing, most mysql tutorials just brush past it and go onto the editing of a databse, but i have no database!
View Replies !
How Do You Create A GUI For The MySQL Database
I just started using My Sql, have been able to transfer over my database from Access, but how do I create the same functionality I had in MS Access ; being able to take in user input, store it into the database, and then re-display it in a specific manner... The data comes in from Excel and a SQL server; there are also user names and passwords for all the users which I think I can just create in SQL Administrator I believe. s is the most efficient, and relatively easy way to design this functionality in a user-friendly environment.
View Replies !
Create Database Mysql Cluster
I have setup a mysql cluster on our web servers, all is working really well. Except I cant figure out how to create a database that scales across the cluster. Can someone point me in the right direction on how to do this. Here is the output from ndb_mgm: ndb_mgm> show Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=2 @192.168.10.3 (Version: 5.0.27, Nodegroup: 0) id=3 @192.168.10.4 (Version: 5.0.27, Nodegroup: 0) id=4 @192.168.10.5 (Version: 5.0.27, Nodegroup: 0, Master) [ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.10.2 (Version: 5.0.27) [mysqld(API)] 3 node(s) id=5 @192.168.10.3 (Version: 5.0.27) id=6 @192.168.10.4 (Version: 5.0.27) id=7 @192.168.10.5 (Version: 5.0.27)
View Replies !
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
View Replies !
Lost Connection To MySQL Server During Query (create Database)
I downloaded the MySQL trail version a few month ago, it worked fine. however after i brought 1 x EMS MySQL Manager Professional (Non-commercial license) and registered but the tool doesn't work anymore... when i try to register a database and try to get it connect, it through me a error message "Lost connection to MySQL server during query". more to it... when i try to create a database at my local host, a error messate says "can't connect to MySQL server on localhost (10061)... PLease help!
View Replies !
Can't Create Database
I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'.
View Replies !
Create A New Database
I would like to create a new database. But something has me wondering. One of the fields "keywords" has to be searchable. Let's suppose it will be a very large database, 20.000 to 50.000 records. Suppose the "keywords" field is limited to 5 keywords. Now what is the best way to do it: - one (1) field called "keywords" and separate the keywords by a comma like this: mp3,download,software,players,music - five (5) fields as follows: keyword1 with data: 'mp3' keyword2 with data: 'download' keyword3 with data: 'software' keyword4 with data: 'players' keyword5 with data: 'music' Which one would be faster? Which one would require the most server resources? What is the best way to do it?
View Replies !
Cant Create Database
i am not able to create database using my userid. I am creating databases using a php script where using root user to do the same is not an option. i have create database permissions. i get the same error both from command line and phpmyadmin 2.6.0. I am using mysql 4.1.7 on linux.here is what i get: mysql> create database sid; ERROR 1044 (42000): Access denied for user 'sid'@'localhost' to database 'sid'
View Replies !
Cannot Create A New Database
I have run the tests in the installation instructions but when I try to create database it the bash shell cannot find the command. I have looked through the various install directories and have not been able to find it using locate.
View Replies !
Create Another Database
I am updating a website that already has a database. So I'd like to know if I need to create another database or just create the tables that I need. There will not be any relationships between my new tables and the old ones in this database.
View Replies !
Cannot Create Database
I am using MySQL version 4.1.21-community-nt, for a very specific reason (i'm trying to back up a database from another server running the same version). at any rate, i cannot create a simple database. i am logged in as root and have full priveleges, and yet when i try to create a database, i get an error:...
View Replies !
Create New Database
I recently installed Mysql into this machine a wonderful pentium IV 2.8 HT Dell computer With 1 GB of RAM and Running (shame on me) WIN XP Everything works fine while i work into the test database but as soon as i try to create a new one the mysql says: "1044 access denied for user: @'localhost' to database 'mytest'" o.k the problem is i am the system administrator i have the account permissions as system administrator not only in this machine but in the whole system, server and domain (o.k it is a windows one but anyway is a domain) i tried to log as every possible combination of users and domain or local machine names and nothing worked to me, does anyone have a clue about what am i doing wrong?
View Replies !
Cannot Create Database With '.' In Name
I'm using MYSQL 5.1.33 According to the document, 8.2. Schema Object Names Before MySQL 5.1.6, database and table names cannot contain “/â€, “â€, “.â€, or characters that are not allowed in filenames. So I guess 5.1.33 should able to use '.' in database name. I open Mysql client, and type in: create database abc.abc; It gave me an error message: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.abc' at line 1.........
View Replies !
Create An SQL Database
Can someone please tell me the coding steps that must be done to create a new and complete database??? For example, I know that you have to create a Table and assign fields to it, but what coding do you do before this step????? Also, what coding do you do after this step??? Again, I ask that you please tell me each coding step that is needed and required to create a complete database???
View Replies !
Create New Database====>
I accidentally deleted my 'test' database, now I have to create a new one. So I did the following steps: mysql> create database DB; ERROR 1044: Access denied for user: '@localhost' to database 'db' mysql> quit Bye C:mysqlin>mysql -root Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 54 to server version: 4.0.21-nt Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> create database DB; Ignoring query to other database ============================== I really don't know how? I use "MySQL Control Center"(database software) to create a database, but it never appear on my command prompt.
View Replies !
Create Database?
Create Database TESTCREATE On (NAME='TestCreate_DATAFILE' , SIZE = 10 , FILEGROWTH = 10 , FILENAME='C:TestCreate.SQLDataFile' ) LOG ON (NAME='TestCreate_LOGFILE' , FILENAME='C:TestCreateTestCreate.SQLLogFile' ) Can I do something like that with MySQL?
View Replies !
Create Database In OS X 10.4
I have got MySQL istalled on my system and now I need to create a database/user. From there I will probably use myPHPadmin to manage my databases (since thats what I'm used to) but I need a database to run that with.
View Replies !
Can't Create New Database
I have install it on a Mac under OS X 10.4.6. During the install I do not think I set it up correctly. The database named test works fine, however I cannot create a new database. I get the error that I do not have privileges. I am using CocoaMySql to admin the database. I can log in with no username and password and admin the test database but that is it. Also I tried using phpadmin, but again I do not have privileges.
View Replies !
Create Database Using Variable Name
I am using an SQL script to create a temporary database backup. While there may be "other" or "better" ways to do this - I am really only asking if the syntax (with tweaking) is possible - and if so what it is. Here is a very stripped down version of what I'm trying to attempt: set @backUpName = 'myBackup'; create database @backUpName;.
View Replies !
Can NOT Create Or Drop A Database
I just Installed MySQL v4.1.14 and had created a Database (from a script). But I would like to redo the Database portion of it but am not able to drop the Database. If I do a "show database;" I still see the database. But when I look in the data directory, it is not there. Below is my attempt the create / drop the DB: mysql> create database testlink; ERROR 1007 (HY000): Can't create database 'testlink'; database exists mysql> drop database testlink; ERROR 1008 (HY000): Can't drop database 'testlink'; database doesn't exist
View Replies !
Create A Database With A Dash In The Name
I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do create database my-site; How then do I create this database, simple as that?
View Replies !
Create An Oscommerce Database
ive been installing a 'test' version of oscommerce, ive got so far and in the manual it says 11. Now, using phpMyAdmin or other mysql tool, create your osCommerce database, and user!!! Can someone tell me how i go about doing this?? Can i use the mysql monitor in the terminal? (im using fedora core 2) mysql> also to create the database is it mysql>create database ???? how do i create a user??
View Replies !
How To Create A New Empty Database
i am just trying my hands on MYSQL. I have installed MySQL server 5.0 , MySQL Administrator , MySQL Database Manager My purpose i to setup a simple database and from there do some simple administration , i am more of a developer but i do want to know MySQL setups When i tried to create a new database instance it shows <Local> so i entered the db name , port# (btw is there any default port# ?) and a user name & pwd but it complains of "-4 XSERVER might be inactive" Could anyone help to get me started with creating my first MySQL database ?
View Replies !
Create A Database :: Where To Start
I've create a simple html website and i have easyphp, so did i have to create the db on local and then upload it or did i have to create it here on the FREE web pages ? I really dont know where to start.
View Replies !
Is A New User Cannot Create Database?
I have recently installed MySql and graphical tools to manage. After installation with root password set, i have connected with graphical admin tool and created a user and set all the previlages to mysql database. I connected with the newly created user and, Using MySql Query browser, i tried to create a new database (or schema) I got an error Access denied for user 'ADMIN'@'%' to database 'TestDB' My host is : localhost My initial doubt is 'Whether a new user, created by root, cannot create his own databases?
View Replies !
CREATE DATABASE Statement
I'm running MySQL 4.0.21 on a Win 2003 Server, and I'm trying to run a script file (the one for phpMyAdmin that creates the Linked Tables Infrastructure). I hit a snag at the very beginning.... The problem is with the following statement: CREATE DATABASE `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; When this statement is run, I get an error message: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8 COLLATE utf8_bin' at line 2 I have tried running this statement by itself, with the same results - so the problem is is definitely with this statement and not the script file itself. Can someone tell me what is causing this error and what can be done to resolve it?
View Replies !
Unable To Create Database
Would any kind soul enlighten me on the error msg? Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource I kept on receive this warnings for almost 50 pages long! and the database fail to create, what could be wrong?
View Replies !
Create Database Problem
Cannot create a database or extend priviledges via mySQL Administrator. Currently using Anonymous user for testing, and get this response. mysql> create database dog; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'dog' So I go the Administrator to set priviledges and I can set them to currently created databases like "test," but not to the folder "def." With permissions set to database "test" I can only create tables, but no databases as I assume the permissions are only for the already created "test" and you can't have a database in a database.
View Replies !
Need To Create Database For Donations
I am creating a form for donors to fill out that includes all their information (first, middle, last name, address, credit card type, number, etc. etc.). Even though e-mailing this info through PHP would be easiest and most convenient, I was told not to do this because of security reasons. Is that correct? So if I'm not going to e-mail the information, I'll need to submit it to a database. This is my first big database project, so I need some guidance please. Here are my questions: How do I create a field that inserts the current date and time of the submission? Should it be a hidden form field, or can the database add the date automatically somehow when the data gets sent to it? What additional fields, other than the submitted form information, do I need in the table? I'm guessing I'll need a 'donation_id' field that will be an INT and will be the primary key (auto-increment). What about indexing? If I have to do this through a database, I'll make a page that will display the information. I also need to have a database field that will hold a value to show if the donation has been processed or not. Should it be a "yes" or "no" or should it be "0" or "1"? I think I can figure out how to get a checkbox to work with that value.
View Replies !
A Script To Create A Database
My main aim is to create a log in system <?php $conn = @mysql_connect("localhost","Andrew","19901623") or die( "Sorry - could not connect to MySQL" ); $rs1 = @mysql_create_db( $_REQUEST['db'] ); $rs2 = @mysql_list_dbs( $conn ); for( $row = 0; $row < mysql_num_rows( $rs2 ); $row++ ) { $list .=mysql_tablename( $rs2, $row) . " | "; } ?> <html> <head> <title>Creating databases</title> </head> <body> <form action = "<?php echo( $_SERVER['PHP_SELF'] ); ?>" method="post">Current databases: <?php echo( $list ); ?> <hr>Name:<input type = "text" name = "db"> <input type = "submit" value = "Create databse"> </form> </body> </html>
View Replies !
Can't Create Database 'boby'. (errno: 13)
Impossible to create a database using MySQL !!! Message : #1006 - Can't create database 'boby'. (errno: 13) I was told : chown mysql.mysql -R /var/lib/mysql chmod 750 -R /var/lib/mysql NOTHING. Absolutly impossible to create a database.
View Replies !
Extract Data And Create Database:
I'm working with this webpage (PHP/MySQL solution) locally and I'd just want to ask if there was a program that could extract all the tables and data from this local database (fx. to an SQL string) which I then could use to recreate the database on the server? I reckon I can't just copy the database, or?
View Replies !
Extract Data And Create Database
I'm working with this webpage (PHP/MySQL solution) locally and I'd just want to ask if there was a program that could extract all the tables and data from this local database (fx. to an SQL string) which I then could use to recreate the database on the server? I reckon I can't just copy the database, or?
View Replies !
Privileges To Add Users Or Create Database
I just installed mysql on my SUSE 9.0 box. I'm using mysqlcc to connect to it but for some reason I don't have privileges to add users or create databases. I tried giving root (login as root) permission but that was unsuccessful. Any ideas?
View Replies !
|
TRACKER
