01-15-2008
MySQL GRANT permission.
Hi,
I'm one of a server administrators. I've the linux root account but I don't know the root password of MySQL (Server version: 5.0.32). I want to GRANT ALL PRIVILEGES to my MySQL account without changing the MySQL's root password. How can I do so?
Last edited by mjdousti; 01-15-2008 at 03:34 PM..
8 More Discussions You Might Find Interesting
1. Linux
Hi,
Is it possible to grant root privileges to an ordinary user?
Other than 'sudo', is there some way under Users/Groups configuration?
I want ordinary user to be able to mount, umount and use command mt.
/Brendan (4 Replies)
Discussion started by: brendan76
4 Replies
2. Programming
i have installed oracle 10g and two databases.
i enter database1 as sysdba and create a user called user1.i give the privileges as "select on" to user1.
i enter sqlplus from the shell prompt. i enter as user1. but when i do "select * from emp" i have a "the table doesn't exist". how can i give... (3 Replies)
Discussion started by: symeje
3 Replies
3. Solaris
Afternoon everyone,
I would want to ask that how/what privileges i should grant to a new user so that the user can clear /disable printing job queue?
Solaris OS: 5.9
Thanks. :b: (4 Replies)
Discussion started by: beginningDBA
4 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
I have to grant sudo permission to a user.
I have searched online and find that /etc/sudoers file needs to be changed with visudo command. As i am new to linux, this is not clear to me. Can anybody take an example and show me how exactly this done.
Thanks in advance! (2 Replies)
Discussion started by: lramsb4u
2 Replies
5. Shell Programming and Scripting
Hi
currently I have a list of *.sql files.
one of the file, terminal is
Prompt Table TERMINAL;
CREATE TABLE TERMINAL
(
TERMINAL_ID NUMBER(8),
EXCEL_TERMINAL_ID NUMBER(8),
MERCHANT_ID NUMBER(8),
SETTLE_TIME VARCHAR2(4 CHAR)
);
COMMENT... (4 Replies)
Discussion started by: jediwannabe
4 Replies
6. UNIX for Dummies Questions & Answers
HI,
I am using centos 6 and finding difficultly in doing 2 below things.
1. i have a user praveen i want to allow him to create cron job of his own. so i have added his user id in cron.allow but still it is not allowing him to edit(even if i have created praveen from root user) or create his... (4 Replies)
Discussion started by: praveenkumar198
4 Replies
7. Shell Programming and Scripting
---file1 ( tables
A
B
C
D
E
F
...
...
Z
---file2
Joe
Bob
Mary
Sally
Fred
Elmer
David (1 Reply)
Discussion started by: rocking77
1 Replies
8. AIX
Hi,
I need to grant read permission to a normal user on sulog file on AIX 6.1.
As root I did acledit sulog and aclget shows "extended permissions" as "enabled" and normal user "splunk" has read permissions. When I try to access sulog as splunk user it won't allow and aclget for splunk user... (6 Replies)
Discussion started by: prvnrk
6 Replies
LEARN ABOUT OPENSOLARIS
mysql_fix_privilege_tables
mysql(1) MySQL database mysql(1)
NAME
mysql_fix_privilege_tables - Fixes MySQL privilege tables.
SYNOPSIS
mysql_fix_privilege_tables [mysql_root_password]
DESCRIPTION
This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func tables to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23
If you get 'Access denied' errors, run the script again and give the MySQL root user password as an argument.
SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysqlshow(1),
mysql_zap(1), perror(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
This manpage was written by Christian Hammers <ch@debian.org>.
MySQL is available at http://www.mysql.com/.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 17 March 2003 mysql(1)