Creating A Database :: Don't Have Permissions
I put the commands in the terminal.
mysql -h localhost -u metsuo -p
Enter password: *******
then I get to where it shows "mysql>"
then I type CREATE DATABASE shinko; and it says I don't have permisson as '@localhost' and I'm in root. Should I give write access to the directory?
View Complete Forum Thread with Replies
Related Forum Messages:
Creating Group Permissions In MySQL
I would like to be able to assign my employees to groups based on what department they are in (all users in accounting would belong to the accounting group, all users in customer service would belong to the customer service group). Then I want to be able to grant database permissions based on what group a user is in: something like GRANT SELECT TO myTable FOR AccountingGroup (obviously not ANSI SQL). Is there an easy way to do this?
View Replies !
Database Permissions
I've got databases on one box i have to transfer to another box, both are running Linux one a Centos4 machine, the other rh9 i think. I could tar up the /var/lib/mysql directory, but i was lead to believe that was a bad idea. I don't know the permissions of the user's and i don't want to give out global permissions. What i was wondering is there a way i can do a mysqldump on the databases on machine1, which will drop everything needed to recreate them in to a .sql file, transfer that to machine2 and then use mysqladmin to load it and have all the settings back in business? I believe they're both mysql4 installs, though machine1 might be mysql3.23, not sure.
View Replies !
Database Creation Permissions
I have setup different MySQL users. I have removed all permissions for the users, and granted them full permission to their default databases I created for the. My question is, how can I grant the users permission to create databases. I want them to have full control to create databases, and delete any that they create. Is this possible, or do I need to create and remove databases for them as requested? I'm running mysql 3.2.5 on Redhat 9. I am not using any host permissions, table, or row permissions on the databases.
View Replies !
Database User Permissions.
I have duplicated a working database which I wish to you. I have also duplicated the code (.asp) which reads, writes and updates the database. All works great when I am logged in to my PC because I have admin rights on this PC but when I test the exact same website with a general users account they get the following error:
View Replies !
Database Permissions (Unable To Write To .CSV File)
My managed server is running 4.1.21-standard. We have been able to connect and read a .csv file into the tables, but can't write or append data from tables to a .csv file for import into another application even thought all permissions have been granted. Is this because File is not in the list of permissions to be granted? Also, first user gets kicked out when second user access the MySQL Account Maintenance page. Second user does not even have to log in to cause problems. Are these MySQL issues or cPanel issues? How can I fix them?
View Replies !
Giving Database User INDEX Permissions
Just setting a few database users in cpanel, I see that one option I can grant is INDEX. And I found this in the cpanel documentation: INDEX (Allows USERNAME to create index on table column in the database. This can speed up a database.) I won't be granting alter permissions, which is what I thought would be needed to add a permanent index? I'm wondering what exactly is meant by this? Does it mean, that they have access to an index key that already exists? Presumably mysql allows the word INDEX in the query that maybe replicates the above? In which case, giving a user INDEX permission means letting them create a "temporary index" in the query?
View Replies !
Creating Database
I just rebuilt my server with Windows 2003 server and I am trying to create a MYSQL database with no success. The server specs are: Windows 2003 Server (IIS6) PHP - version 4.3.10-win32 MYSQL - version 4.0.23 The show databases command shows mysql and test.The command create database forums brings me to a -> prompt but doesn't say that it did anything? The command grant all on forums.* to EGeorge@localhost inentified by password brings me the the same -> prompt but also gives me an hourglass that stays there forever until I kill the process.
View Replies !
Creating Database?
I have mysql installed and running. i want to run a phbb on my server. these are the instructions i am using. i create the databse all right bu when i get to grant command i get syntax error near 'INDENTIFIED BY 'PASSWORD' WITH GRANT OPTION'. I type in GRANT ALL PRIVILEGES ON gators. TO 'hjscm'@'localhost' INDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; [root@axentraserver adminuser]# mysql -u root -p mysql Enter password: (enter the password from oe-mysql.conf here) [...] Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> CREATE DATABASE db_name; Query OK, 1 row affected (0.01 sec) mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'localhost' -> IDENTIFIED BY 'db_pass' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> exit
View Replies !
Creating The First Database
I don't use PHP but .net , but I think you can create a database and colomns directly with a control center ? I have installled MySQL 4 and MySQL Control Center 0.6.3 beta + the ODBC i have started winmysqladmin and enter user = rene / password = rene at the first launch now I open MySQL control center .... connect to the server on the tab general I enter Name = rene Host = localhost User = rene password = rene then I test and get an error >> the memory cannot be read this programm will close i am trying to create a database with mySQL since one week anyone knows how it is normally possible ?
View Replies !
Creating A Database?
I've installed MySQL (5.1.30) on my PC using Xampp (version 1.7.0). I haven't created a log in or username, or anything like that. I can access MySQL to look at databases and work on existing databases, but I can't create a new database. When I go to the mysql> prompt and type; Code: CREATE DATABASE ijdb; I get the following error; Quote: ERROR 1044 <42000>: Access denied for user ''@'localhost' to database 'ijdb' I've also typed every variation I could think of, of the following at the mysql> prompt; Quote: mysql -h localhost -u root -p and everytime I do it I'm given the -> prompt, as if MySQL is waiting for more code. When all this didn't work, I opened phpMyAdmin (3.1.1) to check that there is a user called "root" with full privileges - there is. I also created a password for this user and entered it into Quote: mysql -h localhost -u root -p but I still get the ->. What do I need to do so that I can create a DataBase?
View Replies !
Creating An Efficient Database
i'm currently writing a web based catalogue system in php using a mysql database. the catalogue has a number of products in it from different brands. i would like to know if it is more efficient to have each brand in a separate table then a "master" table just listing the brand name and corresponding table or all the products in one large table and a "master" table listing each brand in the large table. the large product table would of course have a field to state which brand the product was from. the efficiency would be based on users being able to access the database via html browsers using php and also search the database.
View Replies !
Creating A MySQL Database?
I'm a complete newbie with MySQL and only really started trying to learn about it today but i'm confused as to how i'm supposed to create a MySQL database. I tried downloading the MySQL Administrator as it sounded like the right program to create and edit a MySQL database but it seems to want a server to connect to or something. I was told i would be able to create and edit MySQL databases on my local system and then upload them to my web host when i get one, is this possible and if so can someone give me some idea of how and what programs/runtimes/whatever i will require in order to do it.
View Replies !
Creating Database Through Hibernate
If i first create this database manually everything is fine. But for testing and production this database needs to be able to be dropped and created at startup. My configurations are as follows: <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost/testdb"/> <property name="username" value="root"/> <property name="password" value="pass"/> </bean> <bean id="sessionFactory" parent="baseSessionFactory"> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="hibernate.hbm2ddl.auto">update</prop> <prop key="hibernate.show_sql">false</prop> </props> </property> <property name="mappingResources"> <list> <value>com/irise/user/User.hbm.xml</value> <value>com/irise/project/Project.hbm.xml</value> <value>com/irise/group/Group.hbm.xml</value> </list> </property> </bean>
View Replies !
Creating A Test Database
Go to Windows Start menu, choose Run, type: c:Program FilesMySQLMySQL Server 5.0inmysqld-nt.exe After I type that, it displays the command prompt for about 10 seconds, then flashes away. Now, it tells me I am ready to create a test databse using the "mysqladmin" It says, Go to Windows Start Menu, Choose Run, type: c:Program FilesMySQLMySQL server 5.0mysqladmin" -u root -p create testDB; ...then hit enter. It should prompt me to enter a password, I get an error saying I might have typed something wrong. Take a look at the line it tells me to enter. I notice only ONE (").
View Replies !
Creating A Variable Database
I'm making an application that will show a user an html form (using php and mysql). The form is created by that person's manager, which will have custom fields on it. There will be roughly 20 managers, and each manager may have different forms, but some of the fields will be the same (like ID, name, etc). What i've done so far is created 4 tables, items (which are the field names on each of the forms), ItemsSelect(which handles any select html), User(which just has the userid and accesslevel in it, plus 'userfieldstoshow' which tells that user which fields they'll be seeing', and ItemUser, which tells exactly what userid links with each itemid. I probably could have explained that better, but it just basically creates a dynamic form each time a new person loads the page, which shows them which fields to fill out. The PROBLEM is here is i can't figure out which way to store the data. I'm starting with 1 table, and each of the columns will be labeled something arbitrary like 'field 1', 'field2', and that will link to the itemid, and store all the data for which item is in that table. Things that are common I will make, like ID, name, phone, what have you, but I can't decide if I should have a finite amount of fields to be allowed to added (as there will be 20 managers, each with X number of custom fields).
View Replies !
Creating MySQL Database
I'm developing an e-commerce site and have got this for my database: CREATE TABLE `products` ( `prodnum` varchar(10) NOT NULL default '', `name` varchar(50) NOT NULL default '', `category` text NOT NULL, `image` varchar(255) NOT NULL default '', `description` text NOT NULL, `price` text NOT NULL, `dateadded` timestamp(14) NOT NULL ) TYPE=MyISAM; What I want is to create an admin section where I can add a new Product using a PHP page with a form - add product number, name, description, product image, price and date added. Then I want to be able to specify which Product Category the product is added to using a Drop Don box in the form. Is my SQL correct to do this, or should Product Category be a separate table? How do I get the form to post the data into the correct category? It works OK as above except for displaying the product in the correct category. Also, the date does not display on the page correctly. It comes out on the page as 20050602014511.
View Replies !
Creating A Database If Not Exists
I have just started with MySQL and i have question about creating a database. I want to create a database only if it is not already created. So is there some sql that i can write like there is for creating a table "create temp table if not exsist" I would like to write something like "create database temp if not exsist" or is that not possible whene creating a database. If not why?
View Replies !
Creating A Database Of Pictures
I want to setup a database for my pictures on my site so that people can access the database and retrieve pictures from the database instead of me placeing them all on the page which would make my page huge.
View Replies !
Creating A MySQL Database
I've been trying to create a mysql database on my school's server to no avail. It seems as if I need a root user to do it for me; I'm wondering if there is such a way to get around being a root user.
View Replies !
Stopping Anyone From Creating A Database.
How can I stop people from creating a database on my MySQL server? eg if you used PhpMyAdmin you can access my server on my computer by changing the host name variable to my IP address. How can I stop that from happening so that only I can create databases.
View Replies !
Creating Relational Database And Normalization
I need help with creating a relational database and normalizing it. I've been studying the process of creating a relational database, however I am unsure if I am doing it correctly. Below is a sample list I have created (on paper)of my database design. Can someone review and let me know if I am doing everything correctly and give me suggestions for improvement? Code:
View Replies !
Creating Mysql Database On My Machine
I got complete application files and database files which is in the format of as .sql and i need to recreate this application on my matchine i have already setup application on my iis server but when it comes to setup the mysql database from those .sql files....
View Replies !
Error 1044 Creating Database
I try to add a new schema to my database (MySQL 5.0.11). No matter what I do, I always getting error 1044: access denied for user 'root'@'%' to database 'test' I did it in this way: mysql -u root -p password: ************ Welcome (.....) mysql> create database test; ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'test' mysql> Using tools like MySQL Administrator or SQLyog showing me, that the root user has all rights granted to all tables, but all programs are not able to create a new database.
View Replies !
Creating User Login With Database
I'm fairly new to using databases and I am wondering how you go about creating a user login with your database. I need to create a login system for a website. Would you use a CREATE USER statement every time you want to add a user, or is that a way for having developers access the database only? I also thought of creating a user table that would contain the users name and password, but how secure would that be?
View Replies !
Creating A User For Only One Database For The Web/ FORGET IT
If I wanted to create a user for only my website to only have access to one database and they will be connecting via php, what is the best way? I should manually insert into the users table, correct? INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); This is the example from mysql docs, but the whole page is huge and seems complicated. Will this mean that only a user coming from the local host will get in this way? And where would I specify the database? I'd like to have just php connecting to the database asside from root and that user only accessing one database to do inserts/updates/deletes and selects.
View Replies !
Creating A Database For An Organisational Chart
I'm considering making my organisation's organisational chart dynamic using PHP and MySQL. I'm just thinking about how to implement the database... The chart resemblies something like... ----------------------------Department ------------------------------Director -----------Section1--Section2--Section3--Section4 -------------HOS--------HOS--------HOS--------HOS SubSection1-SubSection2 ----Staff--------------Staff ----Staff ----Staff etc... where HOS is Head of section. If I had a table with all the section names (inc department name) with a forgein key reference to a table called levels so we can identify what type of section it is - e.g level 1 - Department, Level 2 - Section. How could I express in the database that SubSection2 is under Section1?
View Replies !
Granting Acces And Creating Database
here's a grant statement. GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $dbname.* TO '$host' IDENTIFIED BY '$passwrod' I copied it from the mysql manual so it "should" be correct but when i run it i get this error: Access denied for user: 'majdkgf_majdgfx@localhost' to database 'test4' Now the problem is, if i create the database first, i need the user set, and if I put the grant before creating the database, i need the database.
View Replies !
Creating A Database Named Login
I am logged into mysql as root and i typed this: mysql> CREATE DATABASE login database; 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 'database' at line 1 mysql> CREATE DATABASE login database -> As you see I get a error when tryign to create a database called "login database" This is my first tiem creating a database so i dont know how to fix it maybe you guys do?
View Replies !
Creating A Database, Doesn't Appear In Left Hand Panel
I have access to my phpMyAdmin control panel. On the left hand side of the split screen it says "home" and a drop down box with existing databases listed. In the right hand side of the screen are links to MySql documentation. I can't find a box to run the command. CREATE DATABASE mydatabase_db; ???? If I select an existing database from the drop down menu on the left, I get the table contents of that database in the right hand side of the screen and below that a box to run the Mysql statements in, will running a create statement in the box interfere with the database I just chose ?? Secondly if I create a new database how do I make it appear in the drop down list of databases on the left ? I have run a create database statemen and it has said database created successfully but it doesn't appear in the drop down box on the left ?
View Replies !
Creating / Managing Database(s) Cross Platform
Is it possible to create / edit database(s) in my iBook laptop and copy the database files straight back to the Windows 2000 server? Coz I wanna do the design and testings in my laptop and 'migrate' it to the server once it's finsihed debugging.
View Replies !
Creating First Database On Mysql 4.0.21 Apache 2.0.52 Windows Xp
started mysqladmin 1.4 then i started mysql monitor by clicking on it in the mysql folder and tried to create a database like this mysql> create database testdb; mysql>got error error 1044:access denied for user: '@localhost' to database 'testdb' do i need to set up a user or is there like a default user sign in i need to do? or some kind of configuration i have missed?
View Replies !
How Can I "see" A Table In A Database On A Remote MySQL Server After Creating It
I used the following SQL to create a new table in a database on a remote MySQL server by copying one already there. I know the table exists SOMEWHERE in cyberspace. I can read its data, write to it, delete from it. But I cannot see it. The only way I know it exists is by running this SQL from Access 97 pass through query: SELECT ALL new_tbl.name FROM new_tbl The database resides on a MySQL server that was created with a single table (named test) in it for testing purposes. I ran the following SQL to create another copy of the table in the same database named: new_tbl CREATE TABLE new_tbl SELECT * FROM test; I cannot see the new table in the Access 97 database window under the Tables Tab. Anybody know how to overcome this? Its a severe drawback to programming efforts not to KNOW what tables are in your database.
View Replies !
Permissions On Mac
I used MAMP to set up MySQL and Apache on my Mac and installed Drupal. Everything was working fine but I thought that I had forgotten to change the password for the 'root' user in mysql. So,with MAMP when you go to "localhost:8888 it gives you a start page where you can access mysqladmin and others. I used mysqladmin to change the root user properties but now when I try to launch the start page I get "could not connect with mysql server" Any idea how I can get to MySQL another way and fix it without having to reinstall? My Drupal installation still works so I know MySQL is working but I can't get to the admin/start page anymore. Also, I'm a complete newb at this stuff.. I know I can go to a terminal session on my Mac to access mysql directly but I don't know enough about it to do anything.
View Replies !
Default Permissions
This is a fairly simple question but I'm new to mySQL. To log on to mySQL I need to type at the prompt: mysql --user='username' --password='password' as opposed to just typing mysql and being recognized without having to type identification. Anyone know how I can change this?
View Replies !
MySQL Have No Permissions
I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting permissions correctly. Can anyone tell me which files and paths I should check (and change)? Ideally, I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
MySQL Permissions
I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
Permissions Change
Running MySQL 4.0.18 (upgraded from MySQL 3.x), I can set the host for a user to "%", and can connect from localhost just fine, as well as remote locations.On another server running 4.0.21 (clean install), if I set the host to "%", I cannot connect from localhost unless I also set a "localhost" entry as well for that user.
View Replies !
Permissions With New Db's
I've got php script that created a database, then the tables in the database. The user in which the script is run, doesn't have the permissions to create a 'new' db. Moreover, mysql says that because the user is trying to create a new db, and there isn't a row specifying that the use has permission, doesn't allow the user to create the db. My solution is that I can create a row in the mysql.db table that will allow for the user to have proper permissions. My problem is that once I insert that row, it takes another post to the page for the permission to actually take hold. Is there a way to have the permissions take hold sooner? Some of the things I have tried would be toRedirect the page to (with a php header call) to re-load the pageClose the mysql connection so that a new one would have to be opened
View Replies !
Resolving Permissions
I have mySQL Administrator (and subsequently mySQL) installed on my iBook. I want to connect to mySQL on my Red Had Linux 9 test server with the mySQL Administrator, but I get the following error message: Code: Could not connect to mySQL instance at [SERVER IP ADDRESS] Error: Host '[IBOOK IP ADDRESS]' is not allowed to connect to this mySQL server (code 1130) I'm sure there's an easy fix for this, but since I'm a bit new at this, I'm not sure where to look.
View Replies !
User Permissions
Is there a special permission required for a user to be able to run a "select ... into dumpfile" statement? I'm getting a 1045 error when attempting this on my server. I've already verified that file permissions are not an issue.
View Replies !
Custom Permissions
I need to assign different 3 different types of users, each with his own permissions and am unsure how to proceed. One of these users will require remote access to all records. I have mySQL 5 and mySQLadmin tool. Both are installed on WinXP and mySQL will be accessed through PHP's connection functions. Can someone show me an example of setting a user with specific table and row privileges for security purposes? ie: a a user can't modify adata in x table, only read. Another user can write in rows w and x of table y only and can read all of y table but not table z.
View Replies !
Trust Permissions
I am trying to configure a mySQL server on XP machine, and wish to allow ASP.NET application access the database from a remote machine. 1. How do I set Trust permissions to a catalog? 2. How do I allow remote connections?
View Replies !
Add Host To Permissions
Typically, one does something like "grant x,y,z on db.* to user1@localhost identified by 'password'". Is there a good way to clone the permissions for "user1@trusted-host1" et al? Particularly sometime later when one doesn't remember exactly what "x", "y" and "z" were exactly? I can look at the bazillion settings already there, but it's rather a pain to count exactly how many '"",''s and '"y",''s have to be where in the insert and what I really want is to just clone the entry, changing one field...
View Replies !
|
TRACKER
