User Privileges In Version 4.1.7(linux)
sql:
GRANT USAGE ON *.* TO 'shinestb'@'localhost' IDENTIFIED BY 'shinestb';
FLUSH PRIVIELGES;
an error return at login time:
./mysql -ushinestb -p
ERROR 1045 (28000): Access denied for user 'shinestb'@'localhost' (using password: NO
why? version < 4.1 is ok.
View Complete Forum Thread with Replies
Related Forum Messages:
Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables in different databases. Now I have to create serveral more users with the same permission. Is there a command in MySQL that allows me to create the new user by copying the privileges from a template user?
View Replies !
Linux Version
I have a need to setup a MYSQL cluster, however, I do not have ANY experience of Linux and you cannot set up the cluster on Windows currently. I learn fairly fast, but would like someone to recomend a version of Linux that would happliy support the MYSQL cluster and also has some good installation instuctions!
View Replies !
Using MyODBC (Linux Version) - Bracketed UNION
I've come across a strange issue when using UNION via MyODBC on my Fedora linux box (I'm using MySQL 4.1.3-standard-beta) **This doesn't work: (select a from tbl_name where a=10 and b=1 order by a) union (select a from tbl_name where a=11 and b=2 order by a) order by 1 (took this straight from the MySQL manual) **Removing parentheses doesn't work either: select a from tbl_name where a=10 and b=1 order by a union select a from tbl_name where a=11 and b=2 order by a order by 1 **But this does work: select a from tbl_name where a=10 and b=1 union select a from tbl_name where a=11 and b=2 order by 1 - so it appears that ORDER BY is not allowed in an individual select when it is being amalgamated with UNION (or UNION ALL). Interestingly, the first statement works fine when executing from the MySQL command line. Has anyone else spotted this, and is there a workaround (other than not ordering select clauses that are UNIONed together)?
View Replies !
Preferred Linux Version For Mysql Development ..
I am planning to perform some development on the mysql kernel, which i hope to submit to the group later this year. Would you please tell me if there is a preferred version of linux ... I am not fussed but I am about to re-org my computer anyway, so any preferences or endorsements would be welcome.
View Replies !
A User Dba Privileges
I need to give a special user admin rights to the databases he creates. As there is no dedicated MySQL database server for his needs yet, we created a special user on a multi-purpose MySQL server; this special user has the rights to do everything only on databases he creates. To distinguish his databases among others, we require his databases' names to be prefixed by "PNCC_". Here's how we did the trick: Once logged in as DBA: mysql> GRANT ALL ON PNCC_.* TO fred@my.fqdn.com IDENTIFIED BY 'some_password' WITH GRANT OPTION; (The query ran OK) mysql> UPDATE db SET Db='PNCC_%' WHERE db='PNCC_'; (The query ran OK) (We had to do two different commands, as GRANT does not seem to accept wildcards). From now on, after having flushed privileges, user fred@my.fqdn.com can create databases with names prefixed by "PNCC_", create tables within these databases, and populates them. But this user would like to have the possibility to create users with special privileges on the databases/tables he previously created. The question is: how can I grant fred to create users with rights ONLY on PNCC_<some name> databases, and nothing else (ie. no access to other databases, nor on mysql.*)? Do I need to insert a special row within mysql.user? If so, which one?
View Replies !
User Privileges?
I'm in the root user account. Lets just say I have three databases called "database1","database2","database3". I also have three users called "user1","user2","user3". Now what I'm trying to do is to only allow user1 to acces database1. So when they login all they see is their database. I want them to add tables and do everything along those lines, but I don't want them to see other databases or create databases themsevles. I can't seem to get this right. How do I go about this? I am using phpMyAdmin version 2.6.1.
View Replies !
How To Set User Privileges
How do I need to set Privileges so that a user can create and modify their own databases? I am running MySQL 3.23.53 with phpMyAdmin 2.5.4. I have multiple DBs and users. I setup up a new user and database with no problem. The user can only see the new database as it should be. I would like to allow the user to be able to create their own databases. Right now in phpmyadmin, when they create a new database, they cannot create tables in it, and they can not see the database they just created in their list of databases. Although I can see the database they created with my admin user. When the user First creates a database and tries to create a table they get "select command denied to user". I gave the user global select, but as soon as I do they can see all the databases. I was guessing this is just a Privilege issue, but I am still learning about SQL privileges.
View Replies !
Changed User Privileges And Now I Can't Log In
I read several web sites and O'Reilly's book on MySQL about securing the system tables. I removed several users and, as advised inthe book and web sites, changed the user "root" to another name with another password. I removed the site name as a host but kept the IP address. Now when I use phpMySdmin to get back in, it let's me past the login popup BUT it gives me the message: Error MySQL said: Access denied for user: 'root@localhost' (Using password: YES) The data in the database is not important but the database structure/definition is. I'd like to find a way to back up or dump that. Then I can reload MySQL and start over.
View Replies !
How To Export User Privileges
I am working with MySQL 5.0 and phpMyAdmin. I know how to export (dump) the tables and data of the database with phpMyAdmin, but I couldn't find a way to do the same for the user accounts and their privileges.
View Replies !
No Privileges For Root User
There is no privilege for root @ % for create user, create view, procedures etc. I tried to edit the user table directly. But it doesnt work. Please help to find a solution.
View Replies !
MySQL User / Privileges
1. Does it cause problems if there are multiple users with the same user name? 2. If 'localhost' is specified for the user host, does this mean that they can only gain access if they are logging in from the same host address where mysql is running?
View Replies !
Assigning User Privileges Error
I created a user 'cody' % and localhost and try to assign privileges to his database 'cal_cody' For some reason it don't work, posting this weird thing in forums didn't help either. so I tried: mysql> GRANT ALL PRIVILEGES ON cal_cody.* TO 'cody'@% IDENTIFIED BY 'access'; Query OK, 0 rows affected (0.00 sec) also tried: mysql> GRANT USAGE ON cal_cody.* TO 'cody'@'%' IDENTIFIED BY 'access' Query OK, 0 rows affected (0.00 sec) then tried the same for 'localhost' then even flashed the privileges and even reloaded the mysql service doesn't do jack Is there something wrong with my command, or is there a way to do this through phpmyadmin?
View Replies !
Create User With Full Privileges As Root
I am trying to create a user with full privileges in addition to the root account, without that user being able to modifiy or even see root's databases. (My goal is to have a user that can create and edit databases, but without being able to access roots stuff). Does anyone know how to do this? And while on the topic of users, when doing a grant to username, is it possible to see if the username already exists and to stop the overwrite of that users priveleges?
View Replies !
How To Grant 'create Database' Privileges To A User
I created a user and wanted to allow he to create a database, how to grant the 'create' database privielege to he. > create user joe identified by '123456'; > use mysql; > update user set Create_priv='Y' where user='joe'; I know I can update the user table,but I'd like to know if these is dedicated statement for this purpose
View Replies !
Login As Root User, And Grant Create Database Privileges
I am new, and I have been trying to find info on this unsuccessfully. Ok, so I am using Unix Terminal from my Mac. From the command prompt, I use Shell>/usr/local/mysql/bin/mysql to log in to the localhost user. Now, from the command prompt, i have tried using ,mysql -u root, and it says command not found!
View Replies !
User Mysql On Linux
I´m using Red hat Enterprice WS 3, when I install mysql (version 4.1.7) on linux, everything ok, but when I type # mysql error ocur: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
User Table And Version
I am using mysql 3.23.54 that came bundled with RH9. When I do a show = databases there is no user table, I am working through the reference = manual for 4.0 is the reason there is no user table because of the = version? also I have tried updating to version 4.0 using the RPM = available from the mysql site but on logon the version still says = 3.23.54 and still no user table; any ideas?
View Replies !
User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything seems to run fine except User Administration is *extremely* slow. If I click on "User Administration" in the sidebar, it takes about 2 minutes (seems like forever) before the window comes back with the infomation. All the other functions seem to function fine. Is it because I'm using mysql-administrator on a remote host? Do I need to move and rebuild the server to a newer Linux version? mysqlcc doesn't have this problem at all. (It's using the libraries from MySQL 4.1 that the databases were migrated to.)
View Replies !
Dont Start If The User Dont Have Administrator Privileges On The PC
I instaled MySQL in a computer (with widows XP) that not always is loged with a user withthe computer administrator privileges. when a person whitout administrator privileges is the first person that logs, the DataBase dont startup until an administrator logs on. What can i do to allways startup the DB without care the computer's administrator privileges?
View Replies !
Install New Version Of Mysql With Old Version Running
I would like to install the new versin of mysql but currently i have mysql version 3.23 running... I need to have 2 version of mysql running at the moment in win2000 for different app. what is the steps for me to install the new version of mysql without causing error and able to run concurrently.
View Replies !
Rolling Back A DB From Version 5 To Version 4
I've got a local MySQL DB with my MediaWiki data that was created in version 5.0.17, but I recently discovered that my webhost is running version 4.0.27, and when I tried to import the database as-is, I received an error. I'm looking for suggestions as to how I could roll my database back to the older version of MySQL, in case my webhost decides not to let me upgrade. I've considered using an intermediary, such as converting to MDB or CSV, but so far I haven't had much luck with finding a tool to do so without spending a pile o' cash.
View Replies !
Error 1142 - Mes. The Following Occured: SELECT Command Denied To User Xx@hostx.com For Table 'user
When trying to do anything to do with "User Administration" in MySQL Administrator 5.1 connecting to a remote MySQL database, I get the following message when I click on the "User Administration" icon/text in top left frame. Verbatim quote apart from my connection details which I am anonymising): A MySQL error was encountered. The message is: Could not fetch user names. The following occured: SELECT command denied to user xxx@hostxxx.xxx.xxx.com for table 'user' (1142) No I have looked through search and found the following: http://lists.mysql.com/mysql/134369 Unfortunately that tells me that it has happened to someone else but that's about it. What is one supposed to do with the fix? I am wondering if this is why I cannot create ordrop any tables with this username at the moment, even though it is the Admin level username....
View Replies !
Own Privileges
Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some = table? I'm using PHP4.
View Replies !
No Privileges
I have installed PHP and MYSQL as a testing server on my local machine using xampp. I then copied over the SQL data folders from my old machine. When I go into PHPMYADMIN the only database I can see is the informationschema and under create new database it states that I have no privelidges.
View Replies !
Privileges
My .net application connects to MySQL database. A developer created this MySQL database and few tables. Now when I try to create another table for my application it is giving me this error "ERROR 1142 (42000): CREATE command denied to user 'username'@'localhost' for table 'tablename'." Even i tried to grant all the privileges to my user name using the below command "GRANT ALL ON dbname.* TO 'username'@'localhost'; but still iam getting the following error "ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'dbname'" Even i tried to create a new database but still i am getting an error.
View Replies !
Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database. I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.
View Replies !
Database Privileges
I was wondering if there is a way to prevent useres from creating databases. The scenario is for a web hosting environment where I would like to let users only use their pre-defined database and not be able to create any additional database (e.g. via phpmyadmin).
View Replies !
Setting Up Privileges
if I can restrict a user from a single table. I want him to be able to create,alter,delete all the tables but one, which I want him not to delete it, not to update it not to create it.Just to use it. Can I do it? As long as I have read there is only the way to give credentials for all the objects of the database.
View Replies !
Changing Privileges
I need help changing host privileges in mySQL server. I am trying to access mySQL server from a remote computer that doesn't have access rights. The online doc sucks; I can't get anything useful out of it.
View Replies !
GRANT ALL PRIVILEGES ON Db.* .....
Having read, as best I could, the docs at http://www.mysql.com/documentation ..., on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter: mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com'; Query OK, 0 rows affected (0.00 sec) but ... [root@max.here.com]# mysql -h mysql.here.com -u root -pmypass ERROR 1045: Access denied for user: 'root@max.here.com' (Using password: YES) "netstat -lt" on mysql.here.com shows the socket is listening okay. tcp 0 0 *:mysql *:* LISTEN.
View Replies !
Grant Privileges Using Like%
I have to grant privileges for users to use databases that start from spm only. So I used the following syntax: grant all on `spm%`.* to username@'%' identified by 'password'; This works fine. Now I log in as the user and create a database named spmtest. After that if I try to use the database spmtest it gives access denied errors. For ex: mysql> create database spmtest2; Query OK, 1 row affected (0.00 sec) mysql> use database spmtest2; ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'database' Can anyone tell me how can we allow users to create databases and then have full rights to the databases they create.
View Replies !
How To Revoke Privileges
I issued following command; CREATE DATABASE mail; GRANT all privileges on mail.* TO user-1@localhost IDENTIFIED BY 'pass1' ; GRANT all privileges on mail.* TO user-1@127.0.0.1 IDENTIFIED BY 'pass1' ; Now I need to revoke user-1's prvileges assigning it to user-2. How can I make it?
View Replies !
None Of Users Privileges
I have no privileges anymore to create a database or view privileges and users. Does somebody know how I can add a user or give my root all privileges again?
View Replies !
Users And Privileges
I just installed mysql and was testing to see if i could setup privileges, now I am logged in as root using the mysql console and wanted to create a user and also give them some privileges.. I am using mysql> GRANT SELECT,INSERT,UPDATE -> ON *.* -> TO bro@localhost -> IDENTIFIED BY 'bobo'; mysql doesn`t give me an error or anything so i figured that it accepted it, but when i try to login using this new user it seems as if its now there. now i used phpMyAdmin to login using root then went to look at privileges and I donb`t see the new user anywhere.. I guess i did something wrong somewhere, any ideas on what it was? abit lost as im new and just following an ebook on this stuff
View Replies !
CAN'T Grant All Privileges
I've searched the forums and don't see anyone with the exact issue I'm having. I've installed MySQL, configured it, logged in as root user....... at MySQL> prompt I typed grant all privileges on *.* to 'potthoff' @ 'localhost' identified by 'xxxxxx' (where x is my password). I then get this symbol, -> What does this represent? I know the user 'potthoff' is not set up b/c I can't log in. I'm following a book "Learning SQL" and I'm stuck at this point.
View Replies !
FILE Privileges
The following is from the documentation: "A user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL server. (This implies the user can read any file in any database directory, because the server can access any of those files.) The FILE privilege also enables the user to create new files in any directory where the MySQL server has write access." How can a user actually read a file from the filesystem through having access to it from MySQL? I understand the LOAD DATA LOCAL, but that only works for certain types of files that contain data formatted a certain way, right? So where does giving the FILE permission become a security issue?
View Replies !
Replication Privileges Not Available
I have 2 servers (linux fedora 4) with mysql-server (4.1.14-1). I tried to make replication available. And when i load data from master on slave , i have this message : ERROR 1219 (HY000): Error running query on master: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation Before on my master server, i attribute these privileges:
View Replies !
Privileges Errors
Is there any limit to the number of privileges I can grant to a user in MySQL? Because I granted 3 privileges to a user (select, insert and update), an only the first and second of them are working... but this occurs only with one of the tables! Creepy! Here are the SQL codes and PHP error generated: :: MySQL :: grant select, insert, update on markkomendes.shows to admgeral identified by 'PASS REMOVED'; :: PHP :: 1142 : UPDATE command denied to user 'admgeral'@'localhost' for table 'shows' Does anyone knows what the heck is happening?
View Replies !
Granting Privileges
I have doubt regarding granting privileges. I have created 'test' user from 'root' user and granted all permission for test. 1) Now if i log into test user is it possible for me to revoke or grant permission for test user itself. 2) Is it possible to grant or revoke permission for other users from test user. when i tried from test user i got the following error message: Access denied for user 'test'@'localhost' (using password 'YEs'). but when i tried from root user it worked. 3) is it only the root user can grant or revoke permission for other users? 4)What encryption technique is used by mysql for password while creating new user.
View Replies !
Mysql Says I Don't Have Privileges
I installed Mysql but now I can't do anything because it says that I don't have privileges. I have tried login out and then back in but it doesn't work. It looks like I change privileges or did something else wrong. Is there any way I can have access to manage the Mysql server (there's no database except the test one in there) or do I need to unstall the whole thing and start all over. If the latter is the correct answer, can somebody please tell me how can I do that.
View Replies !
Backup Privileges
I've just do a full dump of a huge server with lotsa users/databases, and I can see something is missing: On my current production server, in database "information_schema" the table "USER_PRIVILEGES" is populated with 1380 records. On the restored server, this table isn't touched. Look like after a fresh installation of Mysql. Is this a important ? Should I manually backup this table and restore it to the new server ? (The table "mysql.users" with all credentials informations is fully dumped and restored)
View Replies !
Granting Privileges
I can access MySQl as my root user by issuing mysql -u root -p <password> But I cannot seem to grant any privileges to any user for any database. How can I grant these privileges as this user? Every time I try I keep getting the following error ERROR 1044: Access denied for user: 'root@localhost' to database 'mydatabase'
View Replies !
Privileges Disappearing
I have set up a user in MySQL through PhpMyAdmin, with all privileges. This user will randomly lose privileges the privileges Lock Tables and Create mysqlorary Tables. I don't know why it would randomly take these privileges away like every few days or so.
View Replies !
|
TRACKER
