Unable to add users with MySQL 5.5.8 under Windows
Hello, I just downloaded MySQL 5.5.8 (Win64 version) today and installed it on my dev machine. Previously I had MySQL 5.1.51 installed - as I've always felt it was better to uninstall the old before installing the new with Windows, I uninstalled 5.1.51 by doing the following: - As Administrator, I ran DOS prompt and entered NET STOP MYSQL - Ran MySQL Instance Configuration Wizard to remove the current instance - Uninstalled MySQL Server 5.1.51 from Control Panel - Went through my Users, ProgramData, and Program Files folders to delete any references to MySQL. - Reboot computer I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Workbench (5.2.31a). When I run Workbench, I see that the MySQL server is indeed running - I'll also mention that this is my first time using Workbench, until now I had been using the older MySQL Administrator GUI, however it stopped working with 5.5.8. So, back in Workbench, I goto Manage Security under the Server Administration heading, choosing the default Local instance: MySQL server to connect to. Next I click Accounts and finally Add Account at the bottom of this screen. Under Details for Account newu...@% I add in the user name I want, type the password twice, I've tried leaving Limit Connectivity to Hosts Matching as % and localhost. Once I'm finished adding the user, I click Apply - however I'm presented with the following error message: /Unhandled exception: Error adding account accountn...@%:/ I've tried adding a user in MySQL Administrator, as I am more familiar with it. It provides a different error: /Error while storing the user information. The user might have been deleted. Please refersh the user list./ A command prompt pop-up appears with this error stating the following: /** Message: save user: error adding new user entry /I've googled the above error messages and found that either bug reports with similar wording were either abandoned, or supposed to be fixed already. Any thoughts, or should I go back to 5.1.51 and wait for the next point release of the 5.5 line? TIA, -Tim
Re: Unable to add users with MySQL 5.5.8 under Windows
On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Workbench (5.2.31a). When I run Workbench, I see that the MySQL server is indeed running - I'll also mention that this is my first time using Workbench, until now I had been using the older MySQL Administrator GUI, however it stopped working with 5.5.8. So, back in Workbench, I goto Manage Security under the Server Administration heading, choosing the default Local instance: MySQL server to connect to. Next I click Accounts and finally Add Account at the bottom of this screen. Under Details for Account newu...@% I add in the user name I want, type the password twice, I've tried leaving Limit Connectivity to Hosts Matching as % and localhost. Once I'm finished adding the user, I click Apply - however I'm presented with the following error message: /Unhandled exception: Error adding account accountn...@%:/ I've tried adding a user in MySQL Administrator, as I am more familiar with it. It provides a different error: /Error while storing the user information. The user might have been deleted. Please refersh the user list./ A command prompt pop-up appears with this error stating the following: /** Message: save user: error adding new user entry To add, I was able to successfully add a user to MySQL 5.5.8 with phpMyAdmin - would this point to a bug in the GUI tools? Thanks again
Re: Unable to add users with MySQL 5.5.8 under Windows
On 12/16/2010 03:53, Tim Thorburn wrote: On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Workbench (5.2.31a). When I run Workbench, I see that the MySQL server is indeed running - I'll also mention that this is my first time using Workbench, until now I had been using the older MySQL Administrator GUI, however it stopped working with 5.5.8. So, back in Workbench, I goto Manage Security under the Server Administration heading, choosing the default Local instance: MySQL server to connect to. Next I click Accounts and finally Add Account at the bottom of this screen. Under Details for Account newu...@% I add in the user name I want, type the password twice, I've tried leaving Limit Connectivity to Hosts Matching as % and localhost. Once I'm finished adding the user, I click Apply - however I'm presented with the following error message: /Unhandled exception: Error adding account accountn...@%:/ I've tried adding a user in MySQL Administrator, as I am more familiar with it. It provides a different error: /Error while storing the user information. The user might have been deleted. Please refersh the user list./ A command prompt pop-up appears with this error stating the following: /** Message: save user: error adding new user entry To add, I was able to successfully add a user to MySQL 5.5.8 with phpMyAdmin - would this point to a bug in the GUI tools? Thanks again Yes, that would be a problem localized to the GUI tool. Please visit http://bugs.mysql.com/ and either open a new bug describing your problems or add your details to any existing bugs that may already match your description. The team that manages that tool may ask for additional information so please do respond or we will close the bug as No Feedback. Warmly, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How many users access MySQL
Hi If you don't mind keeping the general log, you can periodically parse it. I read that MySQL 5.1 (or some later version) will have an option to keep the general log in a table - that will be very handy. Be careful if you use this option (logging to a table) - while it's an extremely attractive feature, I've read that performance while it's switched on is less than desirable. The 5.1 manual also supports this: Currently, logging to tables incurs significantly more server overhead than logging to files. If you enable the general log or slow query log and require highest performance, you should log to files and not to tables. Hopefully this performance difference will be resolved in future releases of 5.1. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How many users access MySQL
Hi, Is there any way to figure out how many, if any, people are accessing and using our MySQL server? I am aware of the SHOW PROCESSLIST command, but this one only shows how many processes are currently running. I would like to register this information, and be able to analyze it later. Thanks, Shuly, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How many users access MySQL
At 02:32 PM 12/21/2008, you wrote: Hi, Is there any way to figure out how many, if any, people are accessing and using our MySQL server? I am aware of the SHOW PROCESSLIST command, but this one only shows how many processes are currently running. I would like to register this information, and be able to analyze it later. Thanks, Shuly, Shuly, Try show status where variable_name like %connections%. This will tell you the number of connections, not the number of users. I don't think you can find the number of connected users unless you build it into your application. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How many users access MySQL
If you don't mind keeping the general log, you can periodically parse it. I read that MySQL 5.1 (or some later version) will have an option to keep the general log in a table - that will be very handy. On Sun, Dec 21, 2008 at 2:32 PM, Avraham, Shuly avra...@cshl.edu wrote: Hi, Is there any way to figure out how many, if any, people are accessing and using our MySQL server? I am aware of the SHOW PROCESSLIST command, but this one only shows how many processes are currently running. I would like to register this information, and be able to analyze it later. Thanks, Shuly, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: How many users access MySQL
Hi Shuly, you can use the method suggested by Shuly or you cook up your query logs if you need more accurate information. May be you can write a small script to do the job. Regards, Chandru forums.mafiree.com On Mon, Dec 22, 2008 at 7:34 AM, mos mo...@fastmail.fm wrote: At 02:32 PM 12/21/2008, you wrote: Hi, Is there any way to figure out how many, if any, people are accessing and using our MySQL server? I am aware of the SHOW PROCESSLIST command, but this one only shows how many processes are currently running. I would like to register this information, and be able to analyze it later. Thanks, Shuly, Shuly, Try show status where variable_name like %connections%. This will tell you the number of connections, not the number of users. I don't think you can find the number of connected users unless you build it into your application. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=chandru@gmail.com
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]
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]
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]
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]
Re: Deleted all users from MYSQL. What to do now?
* Mike S [EMAIL PROTECTED] [2003-12-21 23:13 +0100]: By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Restart mysqld with the --skip-grant-tables option. Then you can log in again and fix your user table. For details, please refer to http://www.mysql.com/doc/en/Resetting_permissions.html -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deleted all users from MYSQL. What to do now?
By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks _ Grab our best dial-up Internet access offer: 6 months @$9.95/month. http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Deleted all users from MYSQL. What to do now?
If it includes root, you will need to run the mysql_install_db script again then set a pass with mysqladmin By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks _ Grab our best dial-up Internet access offer: 6 months @$9.95/month. http://join.msn.com/?page=dept/dialup -- 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]
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]
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: 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]
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: 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 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 users to mysql
Javier, Friday, March 29, 2002, 8:22:26 PM, you wrote: JG i have the next question. JG how can i add a user to mysql with the console or shell ? JG how can i do the same posses from a php script or application from the JG Internet? It's covered in the manual, look at: http://www.mysql.com/doc/A/d/Adding_users.html http://www.mysql.com/doc/G/R/GRANT.html You can find examples, comments and short notes about your problem there. JG thanks -- 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 users to mysql
hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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 users to mysql
hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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
Re: adding users to mysql
have you downloaded and read the mysql documentation. If not, I would suggest that you do it. these are mentioned in the document. - Original Message - From: Javier Gloria [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Friday, March 29, 2002 7:22 PM Subject: adding users to mysql hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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 - 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
Maximum parallel Users on MySQL
Hi, is there a limit of concurrent connections or threads in MySQL? What do I have to consider when many users (500 - 1000) want to use MySQL at the same time? Greetings from Germany Lutz Maibach EasyCom GmbH
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: 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
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
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 php? echo a href=mailto:$emaillink/a ? 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
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
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 php? echo a href=mailto:$emaillink/a ? 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
?php
$sql = select email, firstname, lastname from user_table order by
lastname;
$res = mysql_db_query(your_db, $sql);
if($res mysql_num_rows($res))
{
while($row=mysql_fetch_row($res))
{
$email = $row[0];
$firstname = $row[1];
$lastname = $row[2];
$message = $firstname $lastname,\n\t Your message
here\n\nDatabase Administrator;
$subject = Your Subject here;
mail($email,$subject,$message,FROM:[EMAIL PROTECTED]\nBCC:your
[EMAIL PROTECTED]);
}
} else {
$error = mysql_error();
echoyour sql statement : $sql BR 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
