04-19-2007
Login as root mysql user, and then use the grant command, e.g.
grant all privileges on db.* to 'user'@'localhost' identified by 'password'
http://dev.mysql.com/doc/refman/5.0/...istration.html
Read sect. 5.7 and sect. 5.8.
Last edited by cbkihong; 04-19-2007 at 09:05 PM..
9 More Discussions You Might Find Interesting
1. Solaris
I want to setup a user on my server and only allow that user to ftp to my server but not to be able to get to command line (telnet /ssh)
I ammended my /etc/passwd so the users shell would be /usr/bin/false and this prevents log on but it also prevents the ftp..
Any ideas? (1 Reply)
Discussion started by: frustrated1
1 Replies
2. UNIX for Dummies Questions & Answers
Hi everybody, im a newer, i want to setup a logfile to capture information about user login/logout (and some other events ex: a user ftp, run a speacial command) on my system in HP-UX, pls help me.
i think only edit file /etc/syslog.conf but i dont know how to do it.
Help me. (3 Replies)
Discussion started by: pwd
3 Replies
3. UNIX for Dummies Questions & Answers
OK, here's the situation. Our regular computer guy left the company without warning. We are in the process of replacing him with someone much more knowlegeable than I, but as of right now, I have been handed the duties. Our mail server is running OpenBSD and I need to set up a new employee with an... (3 Replies)
Discussion started by: Rotting
3 Replies
4. UNIX for Dummies Questions & Answers
Hi folks, thanks for reading this. I have been asked to manage our company's SCO OpenServer 5 system since the old administrator left. I have a very basic knowledge of Unix, but only the basic commands - ls, ps, chmod, etc.
This server holds thousands of programs (converted Basic programs,... (4 Replies)
Discussion started by: citygov
4 Replies
5. UNIX for Advanced & Expert Users
Hello! Can anyone please assist:
Question:
On Linux Server I have created two users John and Matt. I want to give both the users the ability to run 'more' and 'tail -f' commands on the log file in the directory /var/log/test.log. I do not want to give them SU rights.
Can any one please... (6 Replies)
Discussion started by: sureshcisco
6 Replies
6. Linux
Hi ,
I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0
I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH,
ODBCINI , ODBCSYSINI etc .
Getting the error as
Data source name not found, and no default driver specified
ERROR: Could not SQLConnect
... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies
7. Shell Programming and Scripting
Hello Unix scripters,
I have created a small tool that i can distribute to users to check whether they have passwordless login to a list of servers.
The problem in my code below is if user do not have the passwordless login yet, it will prompt them with a password login and my message below... (2 Replies)
Discussion started by: ryandegreat25
2 Replies
8. Web Development
Hi there,
How is it possible to check that:
1) The old setup files are secured or deleted?
For both windows or Unix (0 Replies)
Discussion started by: alvinoo
0 Replies
9. UNIX for Advanced & Expert Users
How do I setup a Samba server to always ask to user and password, when a windows user, prints your files using a shared printer through a Samba Linux Server (CUPS)? (0 Replies)
Discussion started by: viga
0 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)