Change/Create User Permissions
I have a remote db that I want to backup to my local MySQL server (windows). I can do a dump of the db
from phpMyAdmin on the remote server. I try running it on my local server through the MySQL Control Center, and it says "Read Only". I don't have to enter password for root@localhost to login to the Control Center. I assume I don't have permissions to run DDL scripts as this user, and I can't figure out how to change this users permissions or create a new user with different privileges.
View Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
User Doesn't Have Permissions?
I install a mysql backup utility to backup my database if things go wrong. I went to test it to make sure it would work as it emails me the sql file, I deleted my database (using phpmyadmin) and tried to import the sql file which shoots me an error giving me an error that I didn't have permission to create a database. How do I give myself permission to create a database?
View Replies !
View User Permissions
Is there a way to query MySQL to find out what the permissions of the user currently connected For Example: Database: customer_contacts User : cust1 Table: Archives User Permissions: Read Only(SELECT). Is there a way to ask MySQL what User cust1 can do?
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 !
Getting Current User Permissions
I'm on a shared host, but I'm looking for a "global" solution, since I'm writing an installer. I'm trying to get a list of the current user's permissions, I'm trying the user table, but no go. That's most likely blocked. I'm looking through commands, but nothing. Searching isn't turning up either. Is it just trial and error I guess, and catching the errors? What I want to do is to check if the user has the SELECT/INSERT/CREATE/DELETE/ALTER/UPDATE permissions, before proceeding.
View Replies !
Security Question For User Permissions
I've had a site for half a year now, and I have this set up: 1 User with all permission to add/edit/delete etc. data 1 User with SELECT and INDEX permissions My question is do I need to make this (second) user to be secure? Because on my new site I want to my users(going to create user system) to be able to add comments and such and I don't want injections or etc. security hazards.
View Replies !
User Permissions: MySQL DB Design
There is a huge problem I have been breaking my head over in the field of setting user permissions for my CMS. It is still in the development stage so I have all the freedom I need for any adjustments I need to make. My main focus of worry is on how to set the permissions, not in a static, but in a dynamic way. The end goal is to install the CMS for a variety of people. They will then have the control to make their own user groups and permission rules for each group and post. What I am having problems with is the following: Figuring out how to design the database to give me the options to: -Set read, write, edit, move, delete, vote, comment, attach permissions for posts. -Users can only do these things on posts of their user-level and lower or if they are the author. IF the post category allows this. Update: Where I am at now: I have decided to go with assigning 'levels' to each group and for each action. Level 0 is the admin level, the admin can do whatever he wants. Level 255 is a ban. I think I should set level-requirements on different types of posts. Let's say an admin announcement has edit-requirement level 0 where as an author article would have edit-requirement level 1 so only trusted mods can change it but reading-level 10 so all people can read it. (example level values). I was thinking something like this: posts[post_id....post_level_id=ì«'] post_permissions[permission_id=ì«', read_level=ཆ' edit_level=Ƈ' delete_level=Ɔ'....etc] Do you guys think this would be a good way to go? And how would you integrate this into the database? As stated before I edited the post a bit.
View Replies !
Create Temporary Table With Read Permissions Only
In one database I made a query like this create temporary table tempT type=heap select * from orig_table1; insert into tempT select * from table2; SELECT column1, column2, column3, sum(column4) as sumOfColumn4, etc, WHERE date = 20070306 and name = "jan" GROUP BY Column4 order by name desc; drop table tempT; But on another server I only have read permissions. Is there a trick to do such a thing when you only have read permissions. Can I add the output in a variable and then merge the second select in the variable and if necessary empty the variable?
View Replies !
How Do I Create A Table For Holding File Permissions?
I am wanting to make file sharing website. So users can upload files and have control over who access the files. I am wanting to use MySQL for storing the users, passwords, home folders and access permissions for each file. I want to make a table that has the userid and a list of all the files he can access. But I don't know how to make the table that would hold a list of files.
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 !
Restrict User Permissions Based On Column Value
I have a client who wants me to make a web database engine for a softball organization (many teams). he wants him to have administrator rights, and the coaches the ability to update only their roster. The catch is as the players mature and get older their profile will need to move to the next coach. For display purposes (using PHP) I will be doing something like ... "WHERE `team` = '14U'". I want to set it up so only coaches may update their profile if `team` = "14U" is this possible to do within one table? I have PHPmyAdmin so it should be very easy to checkmark permisions on/off. An aside, but I will be doing the database administration via phpmyadmin & via MS Access, which I am almost positive shall work, I believe I've done this before.
View Replies !
Change User Password
i am using mysql version 4.0.27-standard with php myadmin. i do not want to change the root password. in mysql section of my cpanel there is no link to modify or change mysql user, only delete or create it
View Replies !
User Cant Change Own Password
to change a password a user would need update privileges on an entire column, so she could change anyones password. [on a particular table] Am I right? so mySQL users cant change their own passwords, they have to plead with the admin...
View Replies !
How To Create A Change Password Form In Php?
i would like to create a change password form in php using data from tables of mysql .. they have "ID" and "Password".. I want the user to enter his current password, his new password, his confirmation for his new password. then I want to compare between them using double hashing .. I don't know what is that? and how can I compare between these two? I always get a message that the old password is invalid ..
View Replies !
Change The Root User Password
I have just set a password for the root user for logging into MySQL which all works fine by typing: mysql -u root -p A prompt appears asking me for my password which I enter and the usual welcome message appears.I initally set my root user password by typing at command line: mysqladmin -u root password "new password" ("new password" being the password I chose) This all worked ok. However I would like to know how to I change the password for the root user, and how would I also change the password for users that I set up (I assume it would be a similar way)? I am currently running all on my local machine (hence no need to use "-h" anywhere in the login procedure) and running on windows 2000.
View Replies !
Can Not Change Password For Root-user
I can't seem to change the password for my root-user in MySQL. When I go into mysql and type; UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root' AND Host='localhost'; I get the following error; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' How can I change my root-password in the best way?
View Replies !
Can't Change Anonymous User Password
As defined in the Manual under '2.9.3. Securing the Initial MySQL Accounts' I'm trying to change the passwords for the anonymous user and I'm getting an error. mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('password1'); ERROR 1133 (42000): Can't find any matching row in the user table mysql> SET PASSWORD FOR ''@'%' = PASSWORD('password2'); ERROR 1133 (42000): Can't find any matching row in the user table ---------------- Also I'm having another issue. I can't run the commands from the /mysql/bin directory. C:mysql50in>mysqlshow mysqlshow: Access denied for user 'ODBC'@'localhost' (using password: NO) This does work. C:mysql50in>mysqlshow -u root -p
View Replies !
Error In MySQL Administrator When I Try To Change The User Information
I recently install the MySQL 4.1.8-nt-max, and the MySQL Administrator, but when i try to change the information (name, description, email, etc.) in the Administrator I get the following error: " Invalid UTF-8 Error executing query (illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation '=' " Before it happens the Administrator crash down ... Im from Mexico, so my Windows XP regional configurations are spanish / latinamerican. Any ideas about it?
View Replies !
Switch/Change User In Command Line Client
I'm a Brand new User to MySQL DB. Such a Neat DB, so much Better than Oracle IMHO ! I will ask a Question that has been asked on any number of ocassions, But as far as I can see, has not been answered yet. Using the Command Line Client, How do I change (or Login) with a newly created user, created using the CREATE USER command? Whenever I launch Command Line Client, it asks directly for root's password. and from that point on I can't login with another user. How can I do this?
View Replies !
Delete /Change Localhost For Root In User Table
I have updated my Host-Information for root in the users table - and guess what happened - I can't login with root anymore. What is more - I took as update address something like http://serverbla.com. So guess what, I can't login because of the protocol information. Since I have a webshop installed on the machine I would like to reset only this information. Is there any chance to do that without crashing the webshop?
View Replies !
Can't Create New User In 4.1.18
this is what I am doing: mySQL> GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON store. TO newusername@127.0.0.1 IDENTIFIED BY 'newpassword'; I have tried leaving out , LOCK TABLES ON also just ,LOCK TABLES it keeps saying: 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 'TO newusername@127.0.0.1 IDENTIFIED BY 'newpassword'' at line 1 I am using 4.1.18
View Replies !
Cannot Create User
I have a problem with mySql server: I can only run it as root. I use mySql 4.0.15 and phpMyAdmin 2.5.5. on Mac OSX 10.3.2. I run mySql server as root, log in via phpMyAdmin as root and I see there is no user mysql when I click 'Privileges'. When I try to make new user 'MySql' (with minimal privileges) and click 'Go' I get an error 'unknown command'. The corresponding mySql statement is: GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES ON * . * TO "mysql"@ "%"IDENTIFIED BY "*****"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; #1047 - Unknown command How can I log in as user root and not have Grant privileges??? More importantly, how can I create a user mysql with the normal set of privileges (update, create, alter etc)? I have been using the procedure described on the mysql.com website 'A.4.2 How to Reset a Forgotten Root Password' to reset the password for root.
View Replies !
Create User
I have a problem with mySql server: I can only run it as root. I use mySql 4.0.15 and phpMyAdmin 2.5.5. on Mac OSX 10.3.2. I run mySql server as root, log in via phpMyAdmin as root and I see there is no user mysql when I click 'Privileges'. When I try to make new user 'MySql' (with minimal privileges) and click 'Go' I get an error 'unknown command'. The corresponding mySql statement is: GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES ON * . * TO "mysql"@ "%"IDENTIFIED BY "*****" WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; #1047 - Unknown command How can I log in as user root and not have Grant privileges??? More importantly, how can I create a user mysql with the normal set of privileges (update, create, alter etc)? I have been using the procedure described on the mysql.com website 'A.4.2 How to Reset a Forgotten Root Password' to reset the password for root.
View Replies !
Create User In 5.1
i have created a user in phpmyadmin and given the account a password but no matter what I seem to try the user cannot connect with that password (they get in without specifying a password. This is a fresh installation of fedora core 5 in case it matters.
View Replies !
Create User If Not Exist
I have a table of userids/usernames and another table which has data about games consisting of the users. What I want to do is to automatically add a user if they don't already exist in the table. I do this now: Code: INSERT INTO dkblue ( g_id , g_buyin , g_userid , g_finish , g_payout ) VALUES ( $gameid , $buyin , ( select u_userid from usernames where u_name = '$value' ) , $key , $payouts[$key] ) As you can see, the value for g_userid is retrieved from the subquery. But this obviously does not work when the user does not exist. Is there a way to do this in a query or should I make sure all users exist on the PHP end before doing this ? I have just started trying to use subqueries and this one has me stumped.
View Replies !
Can't Use CREATE USER As Root?
I've just freshly installed mysql on my debian system. Binary from the repository, didn't have the nerve to do a source installation. I did mysql_install_db, set my root pw and logged in. Of course, I wanted to create a new user. But what do I get? Your MySQL connection id is 1 to server version: 4.0.23_Debian-7-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> CREATE USER bla; ERROR 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 'USER bla' at line 1
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 New User Account
I need to create a new user account in MySQL. When I installed MySQL, it asked for a password and username which I provided. Now when I open MySQL, it asks for my password but when I enter it, MySQL closes, however, if I hit return it opens MySQL.....any particular reason?
View Replies !
Create User Easy?
Is there an easy way I can just create a MySQL User... and give him the privledges to only do things to databases that he from now on creates..? Or is it gonna be every time I create a database I would have to give him privledge to that database? What type of route would I have to go with that... Also when his user connects to the MySQL Server is there a way I can do a SHOW DATABASES and show only the databases that he has created? He needs to also be able to Create/DELETE/APPEND/UPDATE any database that he creates. What's the easiset way about going around this route? Am I going to have to Grant him Permissions on every database that he creates? Does the root account have to grant the permissions?
View Replies !
Create User Command
I'm trying to create a user with the following command: create user root@xxxxx.lccc.edu identified by payment$; grant all on *.* to root@xxxxx.lccc.edu; I'm getting the following erro: 1064 error in syntax near 'user root......' This is an older version of mysql (1.x) so I'm running the folowing command from the bin directory: mysql -u<admin id> -p<password> < d:create_user.sql
View Replies !
Create User/Pass
how do i create a username and password for a database? i tried using.... GRANT ALL ON database.* TO user_name IDENTIFIED BY 'password' that gave me a "access denied" error. is that command just to set a users accesss level? is there i different command to make a username/password?
View Replies !
Create User And Privs Settings
Here is the idea. I have 1 database 'a'. I want a user that can only 'SELECT' on this database, so I type: GRANT SELECT ON a.* TO 'abc'@'localhost' IDENTIFIED BY 'abc' ; After a while I get an other database 'b'. Now I get confused. I want this 'abc; user to have 'SELECT' privs on this db too, so I can do (I think): GRANT SELECT ON b.* TO 'abc'@'localhost' IDENTIFIED BY 'abc' ; But I can also do: GRANT SELECT ON b.* TO 'abc'@'localhost' is there a difference ? and is this the way to extend privs ?
View Replies !
Create New User ... Error In Syntax?
I'm trying to create a new user using this statement: mysql> CREATE USER 'user1'@'localhost' -> IDENTIFIED BY 'userpass'; ERROR 1064: You have an error in your SQL syntax near ''user1'@'localhost' IDENTIFIED BY 'userpass'' at line 1 My mysql status: mysql> status -------------- mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) The mysql server is on my webhost and I need to SSH to do this. Can you guys enlighten me on what does the error means?
View Replies !
Setting Up User Able To Create Databases
Using mysql 4.1.14, I'm trying to set up privileges for a user such that the user can create databases and then has full access to the databases he's created, including the ability to delete those databases, but not have any access to any databases he hasn't created. This should be trivially easy, but I can not work out how and where to set privileges to do this.
View Replies !
|
TRACKER
