Re: add users in mysql 5.0 ubuntu dapper drake
Always CC the list. You will get better / faster responses. CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] thats is the syntax it tells me to use so i typed CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '**']; were the starts are my password, i hav tried fiddling with the syntax but nothing worked. for the abouve i get this error code, but i dont think the error code will help 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 '[IDENTIFIED BY [PASSWORD] '**']' at line 1 The stuff in []'s means it's optional. If you do create user blah; it will create user blah with no password If you do create user blah identified by 'xxx'; It will create user blah with password 'xxx' -- Postgresql & php tutorials http://www.designmagick.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: add users in mysql 5.0 ubuntu dapper drake
Dimitri Mallis wrote: hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, & then i guess i am suposed to add users there. You've got things confused. 'mysql' the service, you can only run as the root user. So /etc/init.d/mysqld you can only run as the system root user (ie you do "su -" or log in as "root"). To create users inside mysql, read this page: http://dev.mysql.com/doc/refman/5.1/en/create-user.html -- Postgresql & php tutorials http://www.designmagick.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
add users in mysql 5.0 ubuntu dapper drake
hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, & then i guess i am suposed to add users there. i have tried "man mysql" i might have missed the part on how you add normal users to write databases i have downloaded the documentation on the mysql.com site for version 5.0 i followed these steps 5.7.5. How to Run MySQL as a Normal User mysqld worked as root but not as the normal user, i got a error [EMAIL PROTECTED]:~$ mysqld 060705 18:55:12 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test 060705 18:55:12 [Warning] One can only use the --user switch if running as root 060705 18:55:12 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. i got a bit confused with shell> chown -R user_name /path/to/mysql/datadir i think i might have messed up the "/path/to/mysql/datadir" part, i think i put "/usr/sbin/mysqld" no luck with that iether. i know i have missed some thing very simple i just cant see it any help thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
View Users in MySQL 4
Hello! Got a database & I'd like to know what user/s have access to this database. I am able to login to MySQL and can do SHOW DATABASES, Now, I know there's a user supposedly called "kong" using an specific database. How can I tell if that is so? I am new to MySQL, being this the 1st time I ever use SQL commands. Thanks! __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: How To Create Users In MySQL?
http://www.mysql.com/doc/en/Adding_users.html First, use the mysql program to connect to the server as the MySQL root user: shell> mysql --user=root mysql Then you can add new users by issuing GRANT statements: mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO [EMAIL PROTECTED]; mysql> GRANT USAGE ON *.* TO [EMAIL PROTECTED] Dear Caroline Jen, Sometimes this is not quite clear explained in All text books, But the above snip does the trick, Under windows XP. If security is a very important topic for you, A different Operating system could offer you more safety. But please take into consideration that mysql behaves different under Linux and windows. The commands are not exactly the same. Even if it is the same MySQL version. Yours sincerely Morten Gulbrandsen -Ursprüngliche Nachricht- Von: Caroline Jen [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. September 2003 22:33 An: [EMAIL PROTECTED] Betreff: How To Create Users In MySQL? I have the MySQL-3.23.55 installed in my PC. Therefore, I am the DBA without the required DBA knowledge. First, how do I create users in the MySQL database? Second, how do I grant table creation privilege to users? Is GRANT ALL PRIVILEGES ON databasename TO someuser IDENTIFIED BY 'somepassword'; the correct command? Thanks for your guidance. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How To Create Users In MySQL?
not to respond with, 'read the manual', but There is an entire section of the manual devoted to user management, I would start at www.mysql.org click on the documentation link on top, and start there... (user account management is : http://www.mysql.com/doc/en/User_Account_Management.html ) > -Original Message- > From: Caroline Jen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 10, 2003 4:33 PM > To: [EMAIL PROTECTED] > Subject: How To Create Users In MySQL? > > > I have the MySQL-3.23.55 installed in my PC. > Therefore, I am the DBA without the required DBA > knowledge. > > First, how do I create users in the MySQL database? > Second, how do I grant table creation privilege to > users? Is > > GRANT ALL PRIVILEGES ON databasename TO someuser > IDENTIFIED BY 'somepassword'; > > the correct command? > > Thanks for your guidance. > > > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How To Create Users In MySQL?
I have the MySQL-3.23.55 installed in my PC. Therefore, I am the DBA without the required DBA knowledge. First, how do I create users in the MySQL database? Second, how do I grant table creation privilege to users? Is GRANT ALL PRIVILEGES ON databasename TO someuser IDENTIFIED BY 'somepassword'; the correct command? Thanks for your guidance. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: checking permissions and users in mysql
Certainly. http://www.mysql.com/doc/en/User_Account_Management.html On 22 Jan 2003 06:50:27 +0800, Jon Miller wrote: >> Is there a way to check or view in mysql what permissions users have to certain >> databases? >-- >Jon Miller <[EMAIL PROTECTED]> >MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: checking permissions and users in mysql
On Tue, 2003-01-21 at 23:12, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query,queries,smallint > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Is there a way to check or view in mysql what permissions users have to certain > databases? -- Jon Miller <[EMAIL PROTECTED]> MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re users in mysql
I have set up mysql under redhat 7.3 and imported the database from mysql
running on windows.
I have the root user running using passwords, but i cannot get the other
users to log on even thogh the passwords shoudl have been carrid across with
the import.
I have tried to reset the user passwords but still cannot get a logon.
For exmple if i log on and change a user password with:
GRANT INSERT ON stamps.customers TO reguser@'%'
IDENTIFIED BY 'regpassword';
should let me log on as
mysql -D stamps -u reguser -pregpassword
I get the error message:
ERROR 1045 Access denied for user 'reguser@localhost' (Using password = YES)
I have tried changing the password with
update mysql.user set password = PASSWORD('regpassword') and this does not
help
Can anyone suggest what I need todo?
Do I need to drop the users and run the full set of grant scripts again?
Regards
Peter Goggin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
adding administrative users in mysql
mailing, Wednesday, March 13, 2002, 9:41:11 PM, you wrote: ml> I am attempting to add the ROOT user as a MYSQL administrator using the ml> following syntax: ml> mysqladmin -u root password 12345 This command doesn't add user 'root', it can only change password for that user. ml> and I recieve the following error: ml> mysqladmin: connect to server at 'localhost' failed error: 'Access denied ml> for user: 'root@localhost' (Using password: YES)' ml> anyone have any ideas? Are you sure that you have supplied a correct password for user 'root'? ml> Adrian -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
adding administrative users in mysql
Hello, I am attempting to add the ROOT user as a MYSQL administrator using the following syntax: mysqladmin -u root password 12345 and I recieve the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' anyone have any ideas? Regards, Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
users in mysql
3.22.38 Hello guys I figured out how I can set up different user that are able to work on their own dbs. here is my command to add a db and a user; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO bernduser@LOCALHOST IDENTIFIED BY '1234' But a questions: when I have added the user with root, log out and log in with the user bernduser, I am able to see all databases (just the names) is there a way to cut this? Of cource he is only able to work in his own, but I only want him to see his own db bernddb. Thanks Marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: users in MySQL
Sent on Jul 3 by Daniel Aderhold to [EMAIL PROTECTED] aderho> Can anyone give the adress of another manual of MySQL (not from mysql.com). Why is that ??? The manually you're not willing to use is indeed the *official* manual, which also means the more comprehensive one you can think of. If you don't find that comprehensive, there're none (I believe) to please you Sorry -- sherzod_ruzmetov (sherzodR) email: <[EMAIL PROTECTED]> I wasn't recommending that we make the links for them, only provide them with the tools to do so if they want to take the gamble (or the gambol). -- Larry Wall in <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
users in MySQL
Hi. Thanks all for your help. I'm new to MySQL. I'm using win98. Can anyone give the adress of another manual of MySQL (not from mysql.com). Specially I don't know how to manage users in MySQL. Can anyone give me a short explanation? Regards, Daniel Aderhold
Re: mail all users in MySQL database
\n\nDatabase Administrator";
$subject = "Your Subject here";
mail("$email","$subject","$message","FROM:[EMAIL PROTECTED]\nBCC:your
[EMAIL PROTECTED]");
}
} else {
$error = mysql_error();
echo"your sql statement : $sql generated the following error :
$error";
}
?>
HTH
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
-- your next best friend is waiting for you --
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mail all users in MySQL database
Dear Clay Bond, I am really new to PHP, Can you please kindly let me know a code snippet to do the same? i.e. while loop etc. Thanks Love and regards Prasad - Original Message - From: "clay bond" <[EMAIL PROTECTED]> To: "*MySQL mail list" <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 4:45 PM Subject: Re: mail all users in MySQL database On Fri, 27 Apr 2001, Prasad Mhatre wrote: > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? That's pretty simple, isn't it? Pull the usernames from the table, then put mailto:$email>link ?> or something like that in a while loop ... -- /"\ \ / ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \ AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mail all users in MySQL database
There is a php mail tutorial at http://www.phpdeveloper.org/tutorial.php Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "Prasad Mhatre" <[EMAIL PROTECTED]> To: "*MySQL mail list" <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 6:55 AM Subject: mail all users in MySQL database > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? > > Thanks > Love and regards > Prasad > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mail all users in MySQL database
On Fri, 27 Apr 2001, Prasad Mhatre wrote: > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? That's pretty simple, isn't it? Pull the usernames from the table, then put mailto:$email>link ?> or something like that in a while loop ... -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mail all users in MySQL database
Dear All, Can anyone suggest a link where I can find a script in PHP3 to mal all users in MySQL database? Thanks Love and regards Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
