a grant problem.
Hi, a while ago I had problems with users on mysql. I am trying to login as root from the local host using password and I get access denied using password=YES the host column of my user table is set to % and I have done a flush privileges and from other certain hosts I cannot login as root remote my user table looks like host=% and everything else is set to Y Why is this ??? Many thanks, Matt - 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
Can Anyone explain / help with auto_increment fields.
Hi, I have a blank table for some testing. 1 of the fields (the primary key) is an auto_increment and not null. how and what do I insert into this field to start off the recordsets. also once I have set the records going say to 1, what do I then insert if anything into this field for the next record ?? can some one give me a brief explaination of the auto_increment field. Thanks, Matt. - 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: Can Anyone explain / help with auto_increment fields.
thanks a simple but effective explination. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: 23 January 2002 22:29 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Can Anyone explain / help with auto_increment fields. At 10:23 PM 1/23/2002 +, you wrote: Hi, I have a blank table for some testing. 1 of the fields (the primary key) is an auto_increment and not null. how and what do I insert into this field to start off the recordsets. also once I have set the records going say to 1, what do I then insert if anything into this field for the next record ?? can some one give me a brief explaination of the auto_increment field. Do not insert any value into that column. It will be given a value automagically. - 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: Spam - a possible cause ?
I am an experienced programmed and have worked on Unix and with Oracle and Informix for many years. I personally am struggling to get my head around Mysql (getting there now though) I think part of the reason I am posting simple questions is. 1.) I find the manual quite combersome for particular reference, ie I found finding information on adding users and the like quite hard to find easy and had to trawl through similar topics when someone on this list got me on the right track straight away and it was easy to reference the manual from the info given on this list. 2.) My past experience in other languages and RDBMS is hindering my quite bad, ie I am expecting certain restuls from certain situations and not getting them, somethings that seem quite straight forward to people using mysql is totally confusing for someone used to other products. 3.) There is a lot of conflicting information. I have a number of books on Mysql and some conradict each other and the manual, so the only way to make sure is to play/test the methods mentioned, then ask the list when something doesn't make scense 4.) People of All levels join and leave the list each day (I imagane) so reposts are quite common, If they do not apply to me or I don't feel I can help I delete them, otherwist I reply, the number or reposts is becoming a problem due (in my opinion) to a select few elite mysql people, who have strong skills with MySql and have been using it for a while, instead of ignoring the reposts (which I am sure they have seen hundereds of times) they reply back with harsh (again my opinion) or acidic comments, like this was posted 3 days ago, read the manual before wasting our time. This points out peoples re-posts to others who are not so bothered, if they just deleted what did not apply I am sure someone of similar level to the question poster would reply with a helpfull comment. On the other hand these elitist people do provide good info when needed so I don't intend to be too blaming on them. I really like the way this list works, and I have found %90 usefull and had some really indepth discussions on even the simplist questions, giving me a better understanding of the problem that I first asked. Not sure how close to the mark I am but I thought I would put my opinion in. Matt. -Original Message- From: Robert Lucier [mailto:[EMAIL PROTECTED]] Sent: 11 January 2002 19:55 To: jds; Patrick Crowley; Keith C. Ivey Cc: MySQL List Subject: RE: Spam A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - 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 __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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: command mysql -u $user without typing it - getting shafted and annoyed now.
I must be going so wrong here. I deleted the users and started again. added 2 users dba and matt. Both of these have the host of % (connect from anything yes ?) I then do a grant all privileges on *.* to dba@% flush privileges and grant all privileges on *.* to matt@% flush privileges then mysql -u matt -p gives me ERROR 1045: Access denied for user: 'dba@localhost' (Using password: YES) and I am on the local host ??? what the hell is going on I thougth I understood and was getting somewhere. obviously not. Sorry to drag this up again. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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 - 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: command mysql -u $user without typing it ????
Doug, I am running redhat linux 7.1. I have tried these commands, and re-read your mails for earlier, and I understand what these commands should be doing, and how the tables work for secuirty. I have done all that I should have done and I am still stuck. I have have made sure the linux box does not have any login - or network restrictions on and all ports are open, no deny/allow rules etc. all fine. I truley am stumpped. -Original Message- From: Doug Thompson [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 04:39 To: James Montebello; [EMAIL PROTECTED] Cc: Gerald Clark; Ho Kam; MySql List Subject: RE: command mysql -u $user without typing it Matt: I don't remember you saying what machine you're running mysql on. Try adding another copy of the same user only @localhost. My win32 installation requires that for a dos box. The hosting service I use doesn't seem to care as it almost seems to ignore the Host column. GRANT ALL PRIVILEGES ON *.* TO foo@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'password' WITH GRANT OPTION; Good luck. Doug On Wed, 9 Jan 2002 20:38:46 -, Matthew Darcy wrote: I was doing a flush privileges. but this was coming up with the same thing no rows affected which to me was concerning. I have now got 1 user working but 1 user not. I am going to delete all users and start again with the users, as at the start I was not doing flush privileges and I was also trying put hostnames without DNS into the hosts field. I may have corrupted the user accounts in some way. I'll keep you posted. Thanks for the help and the good explainations though. I am sure it will be a user error on my part if 1 user is working and another 1 not. Cheers. Matt. -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 19:43 To: Matthew Darcy Cc: Ho Kam; Gerald Clark; MySql List Subject: RE: command mysql -u $user without typing it You must do a FLUSH PRIVILEGES after making any changes to the user permissions before they will actually take effect. This is documented. james montebello On Wed, 9 Jan 2002, Matthew Darcy wrote: query ok I would expect to see, but no rows affected ??? this must mean it has not altered the database at all ?? I created a 2 new users, dba and matt I did grant all privileges to *.* to dba@% I cannot conntect from anything host as dba. I then did grant all privileges to *.* to matt@jaguar.no-dns.co.uk (my laptop) I got the no rows affected message and I cannot connect from the machine jaguar. something must be wrong. I used stand the pricinpals of the grant command but I cannot understand why no rows are affected. It does not surprise me that I cannot connect when no rows are affected. any other suggestions. Thanks for going into detail on this I am learning. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:57 To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it The Query OK, 0 rows affected indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the access is denyed for user @localhostto database mysql message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2
alter table example.
Can anyone give me an example of an alter table syntax that. 1.) adds a column 2.) deletes a column. I am reading the examples in the oreilly book, and it does not work also the Oracle or Infomix syntax doesn't work. can someone give me a clue please. Thanks, Matt. - 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
triggers and references.
Hi, in Oracle I have a test database. there are 2 tables table1 and table2. there is a field on both tables called account_number. on table 1 it is set to auto increment. I have set up a trigger so that when a number is generated in table1 it copies the number to account_number on table 2. Can this be done in mysql and how ? Thanks, Matt. - 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: command mysql -u $user without typing it SORTED THANKS ALL !!!!
I had cleared down the user table, and had the correct entries, BUT I had not cleared down the DB tables, as I thought grant would do this. after clearing down the db table and then granting the privileges it worked. Sorry for the mistake on my part all but I have a better understanding of whats going on. I thank everyone for their time on this problem. one thing though, I am surprised that grant did not alter the db table ? does this surprise anyone else. Thanks, Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 14:00 To: '[EMAIL PROTECTED]'; Carl Troein; [EMAIL PROTECTED] Subject: RE: command mysql -u $user without typing it Matt: Can you check and see if you have more than 1 entry for user in your user table? I wonder if there were more than 1 entry in the user table for user, MySQL might pick the first one which do not allow you to connect using user user. Kam -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 7:31 AM To: Carl Troein; [EMAIL PROTECTED] Subject: RE: command mysql -u $user without typing it Carl, great attempt, but that would be far to easy, I have removed the localhost entry and the jordan.no-dns.co.uk entry, the only place this remains is for root. dba and matt only have 1 entry, which is % so keep I am still in the dark -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 07:37 To: [EMAIL PROTECTED] Subject: Re: command mysql -u $user without typing it Matthew Darcy writes: I was aware of the user table as a standard table. I did a select on it and it all looked fine. Loads of Y's and % for host Yet this user still cannot connect. The only explaination is corruption. It sounds to me like you haven't removed the @localhost entry, but you want user@% to be matched when you connect from localhost. Could that be it? If so, section 4.2.8 is your (rather dull) friend. //C -- Carl Troein - Crdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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 - 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: triggers and references.
I have read through the manual, admitidly not page by page but as a reference. I was aware that triggers where not supported, that is why I asked can this be done and how ? I meant is there a way around this ?? if so what and how. Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 15:30 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: triggers and references. The many simple questions you ask imply that you have not read the manual. Triggers are not supported. Matthew Darcy wrote: Hi, in Oracle I have a test database. there are 2 tables table1 and table2. there is a field on both tables called account_number. on table 1 it is set to auto increment. I have set up a trigger so that when a number is generated in table1 it copies the number to account_number on table 2. Can this be done in mysql and how ? Thanks, Matt. - 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: command mysql -u $user without typing it - getting shafted and annoyed now.
mail seemed to come through out of sink in a strange order. I take it you got the message about grant not altering the db table. Thanks for the help. I leant a lot. Matt. -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 19:32 To: '[EMAIL PROTECTED]'; Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it - getting shafted and annoyed now. Hi Again I just did this to check what you did: SKYROAD#mercury1:/mercury/home/quentin:mysql --user=mercury -p mysql Enter password: mysql grant all privileges on mysql.* to matt@%; Query OK, 0 rows affected (0.05 sec) mysql flush privileges; Query OK, 0 rows affected (0.19 sec) mysql quit Bye SKYROAD#mercury1:/mercury/home/quentin:mysql --user=matt mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 353315 to server version: 3.23.40-log mysql quit Bye SKYROAD#mercury1:/mercury/home/quentin:mysql --user=matt -p mysql Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 353316 to server version: 3.23.40-log mysql quit Bye SKYROAD#mercury1:/mercury/home/quentin:mysql --user=matt -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 353317 to server version: 3.23.40-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye As you can see, it all works fine - when prompted for a password, just pressing return lets me in. Can you post the results of: select user, name, host from user; It may help. Quentin -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 11:10 p.m. To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it - getting shafted and annoyed now. I must be going so wrong here. I deleted the users and started again. added 2 users dba and matt. Both of these have the host of % (connect from anything yes ?) I then do a grant all privileges on *.* to dba@% flush privileges and grant all privileges on *.* to matt@% flush privileges then mysql -u matt -p gives me ERROR 1045: Access denied for user: 'dba@localhost' (Using password: YES) and I am on the local host ??? what the hell is going on I thougth I understood and was getting somewhere. obviously not. Sorry to drag this up again. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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
RE: Sun netra's and MySQL
I have clustered Netra's together before using SUN HA and Vertias VCS. I found for large content avoid the Netra X1 - more so for webstuff, they run on a very slow IDE bus. They work excellently for say processing like the middleware box, or actual webservers but disk heavy apps I would avoid as the disks cannot keep up with the processing power. The Netra T1, what a box worth while in every way, small VERY fast got the new trendy prom cards as an option. Fast disks, excellent processing of an Enterprise Sparc Chip. Great machine. Be warned though sticking external disks on this is not as straight forward as other larger sun kit. There have both got to internal HME class cards in which work really well. Oracle didn't run to great with large ammounts of recrds, so much infact that a web customer we had we had to upgrade. take a look at smg.co.uk this runs 3 webservers on T1's load blanced in hash format, with a alteon load balancer. Connected on an internal address to a Sun 420R with a Disk array running Oracle. The netras run Java, PHP, sendmail, and a couple of other apps. They all had 512 meg of memory but where starting to strain a little. Hope this helps. Matt. -Original Message- From: Christopher Thorpe [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 11:07 To: [EMAIL PROTECTED] Subject: Sun netra's and MySQL Hi all I was thinking of hosting our MySQL database on a cluster of Sun Netra's either tmX1 or tmT1 and was wondering if anyone had any experience of these boxes and how well they work with MySQL. Our database has about 30 tables and about a million rows. Anyone have any ballpark figures on the number of concurrent connected clients and queries per second you can achieve on one of these? thanks and best wishes Chris - 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
still cannot connect to remote database.
Hi, I have connect to the mysql database as root, and added a user called test one with the host field containing a % and all the other options with a Y. In theory I should be able to connect to a remote database as test1 form any host ? is this correct ? I am have tried using mysqlgui and mysql front and connecting to my remote database on my local lan as test 1 I still get host not allowed to connect to this database. I am aware of the db table but I thought that if there was not an enrty in this table the user table rules all ??? can someone help and as well as adding the the answer explain what is going wrong so I can try and understand. Thanks, Matt. - 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
another % question.
in the db table there is the db field. if I put in db1 in this field then the user test1 will only be able to connect to db1. the questions I have (I can't quite figure it out from the manual) 1.) how can I get it so test1 can connect to db1 and db2 but not db3. Do I have to put in 2 entries for the user test1 in the db table. 2.) can I put % in the db field which will allow test1 to connect to all databases. Thanks, Matt. - 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
command mysql -u $user without typing it ????
I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. - 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: command mysql -u $user without typing it ????
I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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: command mysql -u $user without typing it ????
tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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 - 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: command mysql -u $user without typing it ????
query ok I would expect to see, but no rows affected ??? this must mean it has not altered the database at all ?? I created a 2 new users, dba and matt I did grant all privileges to *.* to dba@% I cannot conntect from anything host as dba. I then did grant all privileges to *.* to matt@jaguar.no-dns.co.uk (my laptop) I got the no rows affected message and I cannot connect from the machine jaguar. something must be wrong. I used stand the pricinpals of the grant command but I cannot understand why no rows are affected. It does not surprise me that I cannot connect when no rows are affected. any other suggestions. Thanks for going into detail on this I am learning. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:57 To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it The Query OK, 0 rows affected indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the access is denyed for user @localhostto database mysql message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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 - 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: command mysql -u $user without typing it ????
I was doing a flush privileges. but this was coming up with the same thing no rows affected which to me was concerning. I have now got 1 user working but 1 user not. I am going to delete all users and start again with the users, as at the start I was not doing flush privileges and I was also trying put hostnames without DNS into the hosts field. I may have corrupted the user accounts in some way. I'll keep you posted. Thanks for the help and the good explainations though. I am sure it will be a user error on my part if 1 user is working and another 1 not. Cheers. Matt. -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 19:43 To: Matthew Darcy Cc: Ho Kam; Gerald Clark; MySql List Subject: RE: command mysql -u $user without typing it You must do a FLUSH PRIVILEGES after making any changes to the user permissions before they will actually take effect. This is documented. james montebello On Wed, 9 Jan 2002, Matthew Darcy wrote: query ok I would expect to see, but no rows affected ??? this must mean it has not altered the database at all ?? I created a 2 new users, dba and matt I did grant all privileges to *.* to dba@% I cannot conntect from anything host as dba. I then did grant all privileges to *.* to matt@jaguar.no-dns.co.uk (my laptop) I got the no rows affected message and I cannot connect from the machine jaguar. something must be wrong. I used stand the pricinpals of the grant command but I cannot understand why no rows are affected. It does not surprise me that I cannot connect when no rows are affected. any other suggestions. Thanks for going into detail on this I am learning. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:57 To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it The Query OK, 0 rows affected indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the access is denyed for user @localhostto database mysql message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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: command mysql -u $user without typing it ????
I was aware of the user table as a standard table. I did a select on it and it all looked fine. Loads of Y's and % for host Yet this user still cannot connect. The only explaination is corruption. Although I am still looking at it. -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 21:33 To: Matthew Darcy Cc: Ho Kam; Gerald Clark; MySql List Subject: RE: command mysql -u $user without typing it The mysql user permissions are just a table in the mysql database. Whenever you do a GRANT, you're really just doing an INSERT or UPDATE against this table. You can do SELECTs, INSERTs, UPDATEs, etc. against this table (the 'user' table), just like any other table. The only way to corrupt user accounts is to corrupt this table in some way. There is no magic here. james montebello On Wed, 9 Jan 2002, Matthew Darcy wrote: I was doing a flush privileges. but this was coming up with the same thing no rows affected which to me was concerning. I have now got 1 user working but 1 user not. I am going to delete all users and start again with the users, as at the start I was not doing flush privileges and I was also trying put hostnames without DNS into the hosts field. I may have corrupted the user accounts in some way. I'll keep you posted. Thanks for the help and the good explainations though. I am sure it will be a user error on my part if 1 user is working and another 1 not. Cheers. Matt. -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 19:43 To: Matthew Darcy Cc: Ho Kam; Gerald Clark; MySql List Subject: RE: command mysql -u $user without typing it You must do a FLUSH PRIVILEGES after making any changes to the user permissions before they will actually take effect. This is documented. james montebello On Wed, 9 Jan 2002, Matthew Darcy wrote: query ok I would expect to see, but no rows affected ??? this must mean it has not altered the database at all ?? I created a 2 new users, dba and matt I did grant all privileges to *.* to dba@% I cannot conntect from anything host as dba. I then did grant all privileges to *.* to matt@jaguar.no-dns.co.uk (my laptop) I got the no rows affected message and I cannot connect from the machine jaguar. something must be wrong. I used stand the pricinpals of the grant command but I cannot understand why no rows are affected. It does not surprise me that I cannot connect when no rows are affected. any other suggestions. Thanks for going into detail on this I am learning. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:57 To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it The Query OK, 0 rows affected indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the access is denyed for user @localhostto database mysql message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do
adding users (reference from O'reilly book)
I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y') ; questions 1.) is the % a wildcard, and if so does this mean the user bob can connect from any host ? 2.) the password function encrypts the password. If the password function is missed out before the ('mypass') bit will it enter the password un-encrypted ? or will it just not work ? thanks, Matt. - 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 (reference from O'reilly book)
thanks for your help on this, I would like to use the grant sql command as I am using the latest version 3 of mysql, however I am find problems finding good usage guide for grants. I will update the oreilly mysql book. I need to do this with my bind and apache book too. Matt. -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:50 To: '[EMAIL PROTECTED]'; MySql List Subject: RE: adding users (reference from O'reilly book) Hi If you have a new copy of MySQL use GRANT. If you have an old copy update it. If you can not do this then Yes % is a wild card. Yes bob can use any host at user table is global. Yes you can use clear text passwords. Hope this helps. Simon PS I like using desc tablename PPS Get the new O'reilly book the old one is not so good! -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 09:38 To: MySql List Subject: adding users (reference from O'reilly book) I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y', 'Y', 'Y', 'Y') ; questions 1.) is the % a wildcard, and if so does this mean the user bob can connect from any host ? 2.) the password function encrypts the password. If the password function is missed out before the ('mypass') bit will it enter the password un-encrypted ? or will it just not work ? thanks, Matt. - 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
Password reset.
I just installed mysql under my new linux system. I did a test command of ./mysqladmin -u root password new-password thus setting the root users password to new-password this appeared to work. I now want to change the root users password now that I have the syntax correct. I do a ./mysqladmin -u root -p password test1 this should set the password to test1 correct ? I get this error ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' can anyone explain why this is happening so that I can better understand how this command is working. Thanks, Matt. - 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
MySql Gui connecting to remote server problem
Hi, my laptop is running windows 2000 and is called jaguar. I have mysql running on a linux server called jordan. when I fire up mysqlui and tell it to connec to jordan as root I get prompted for a password. I enter the password (that I have tested and is correct) and it say at the bottom of the gui Host 'jaguar.no-dns.co.uk' is not allowed to connect to this MySQL server how can I fix this. Thanks, Matt. - 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
creating users ??? I must be blind.
Hi, the manual referes to creating users using mysqladmin and mysqlaccess, I have looked at these commands and cannot see how I can create mysql users. Am I missing something that is staring me in the face ? Thanks, Matt. (slowing getting the hang of what is going on now) - 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: MySQLGUI
I am having the same problem. My laptop jaguar is not allowed to connect to my server (jordan) I get jaguar is not allowed. I think it is something to do with granting user root from jaguar to root@jordan ??? I am trying to figure out what is going on ? If you read back I posted a couple of hours back this question. -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 15:42 To: MySQL Subject: MySQLGUI I've downloaded and am trying to use the MySQLGUI as well and had the same problem, but figured it had to me a firewall problem so I opened up port 3306 in my IPchains and it let me through only now it's telling me that the computer I am coming from is not allowed to connect to MySQL server. Anyone have a clue on this one? Thanks, Vernon - 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
just got this through whats going on ???
I never sent a mail to unsubscribe ??? have I been booted from the list or what ?? Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] ql.com Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 23497 invoked from network); 7 Jan 2002 16:10:53 - Received: from mhoro.cc.columbia.edu (@128.59.59.155) by www.mysql.com with SMTP; 7 Jan 2002 16:10:53 - Received: (from www@localhost) by mhoro.cc.columbia.edu (8.9.3/8.9.3) id LAA04140 for [EMAIL PROTECTED]; Mon, 7 Jan 2002 11:16:43 -0500 (EST) To: [EMAIL PROTECTED] Subject: unsubscribe please Message-ID: [EMAIL PROTECTED] Date: Mon, 07 Jan 2002 11:16:38 -0500 (EST) From: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit User-Agent: IMP/PHP IMAP webmail program 2.2.0-pre13 X-Originating-IP: 168.108.118.24 unsubscribe please - 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: MySQLGUI
apologies, I don't have the space to keep all mails as this group puts out a 100+ messages a day I glance through them and if they are not relevant I delete them unless I know I'll need them in the future. -Original Message- From: Doug Thompson [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 16:31 To: [EMAIL PROTECTED]; MySQL; Vernon A Webb Subject: RE: MySQLGUI You need to create a user with login privileges from any location. GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'apassword' WITH GRANT OPTION; AND, as is appended to each post, Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) AND, this answer was posted yesterday in response to an identical question, if you read back. hth, Doug if you read back, this answer was posted yesterday On Mon, 7 Jan 2002 16:01:27 -, Matthew Darcy wrote: I am having the same problem. My laptop jaguar is not allowed to connect to my server (jordan) I get jaguar is not allowed. I think it is something to do with granting user root from jaguar to root@jordan ??? I am trying to figure out what is going on ? If you read back I posted a couple of hours back this question. -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 15:42 To: MySQL Subject: MySQLGUI I've downloaded and am trying to use the MySQLGUI as well and had the same problem, but figured it had to me a firewall problem so I opened up port 3306 in my IPchains and it let me through only now it's telling me that the computer I am coming from is not allowed to connect to MySQL server. Anyone have a clue on this one? Thanks, Vernon - 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: Newbie needs serious help!
try restarting port mapper on the linux box. also make sure swap is not almost used as sockets uses tmp to swap out tcp requests. -Original Message- From: Michael J. Cermak, Jr. [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 19:36 To: [EMAIL PROTECTED] Subject: Newbie needs serious help! I'm running RedHat Linux 7.0 (2.2.16-22) with MySQL 3.23.32... It's been working perfectly until suddenly this morning at 1:40AM it stopped responding. I restarted the whole system, and still nothing. It says Running with the PIDs when I do a mysqld status and when I do a mysqld start it returns OK. However, when I try to go to a PHP page using MySQL, it times out. If I do a mysqld stop, the program seems to freeze (and can, apparently, only be cured by a kill -9). I tried using a -log and got the .err with only: ~ ./mysqld, Version: 3.23.32-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument ~ If anyone has ANY ideas of what to try, or if I need to supply more information, or if I need to ask somewhere else, please let me know! Many thanks, -Mike Cermak HelpOnThe.Net - 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
Using MYSQL and PHP With Vitual Apache Servers ?
Hi, I have a redhat server, running apache 1.3.20. The server is running a couple of virtual servers for different websites. I now wish to add a few new virtual servers/domains to the machine. However (here is the twist) these sites will need to use a different mysql schema each and have some of the content generated with php based on the data from the different mysql databases. Is this possible ??? if so what is needed to configure this setup (just brief), and I would be very interested in hearing from someone who is running virtual servers with each site using a different mysql database. Thanks, Matt. - 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: Using MYSQL and PHP With Vitual Apache Servers ?
this is a perfect explination, I was concerned about the same webserver (split into virtual) accessing different databases. Out of interest can anyone think of ANY problems this virtual setup may cause ? ie memory, transaction time, dns even, just anything at all so I am trying to evaluate possiblities for different ideas. Thanks, Matt. PS is anyone interested in working on any projects, I am new to both PHP and MYSQL and I am trying my hand at some new projects, I am quite competant in Oracle, C++, VB, Unix so it is not quite the same as working with a non programmer. If you are interested drop me a personal mail. -Original Message- From: j.urban [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 15:44 To: Matthew Darcy Cc: [EMAIL PROTECTED] Subject: Re: Using MYSQL and PHP With Vitual Apache Servers ? Why not just create separate databases for each virtual server? It sounds like a perfect situation to create multiple databases, as databases do provide data separation... mysql create database Virtual1; mysql create database Virtual2; mysql create database Virtual3; mysql create database Virtual4; mysql show databases; +--+ | Database | +--+ | Virtual1 | | Virtual2 | | Virtual3 | | Virtual4 | +--+ And then in the PHP code for each website, you connect to the appropriate database. Say for website Virtual2: $dbh = mysql_connect(localhost,user,pass); mysql_select_db('Virtual2'); ... Access schema for website Virtual2 ... http://www.mysql.com/doc/C/R/CREATE_DATABASE.html http://www.php.net/manual/en/function.mysql-select-db.php Good luck. On Sun, 6 Jan 2002, Matthew Darcy wrote: I have a redhat server, running apache 1.3.20. The server is running a couple of virtual servers for different websites. I now wish to add a few new virtual servers/domains to the machine. However (here is the twist) these sites will need to use a different mysql schema each and have some of the content generated with php based on the data from the different mysql databases. Is this possible ??? if so what is needed to configure this setup (just brief), and I would be very interested in hearing from someone who is running virtual servers with each site using a different mysql database. Thanks, Matt. - 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
host not allowed to connect ? where is this config ?
I have a server called jordan, that is running mysql under linux. I have a laptop called jaguar which I am trying to launch the mysql gui on to connet to jordan. I have configured jaguar to connect to jordan, when I click connect it asks me for a password - I have not set the password yet so should this be blank. If I click ok it says host jaguar.no-dns.co.uk is not allowed to connect to this mysql server in the gui window. Is this a password problem or does work have to be done on the server to allow clients in general or the gui to connect. Thanks, Matt. Also is anyone skilled enough to answere a couple of technical questions on compiling PHP4 into apache ? if so could they mail me seperate I would like to run a few things by them. Thanks, Matt. - 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
permisions problem, need to understand what is going wrong to get ontop of this.
-Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 27 December 2001 14:08 To: Count Schemula Subject: RE: Re: host not allowed to connect ? more problems Hi, I have re-read and think I understand a little better (think being the correct word) I have decided to set the root password - and then add some users. first of all I tried ./mysqladmin -u root password $thenewpassword this gave me ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I decided to then try ./mysqladmin -u root@jordan password $thenewpassword this came up with ./mysqladmin: unable to change password; error: 'You are using MySQL as an anony mous users and anonymous users are not allowed to change passwords' the problems are 1 why can mysqladmin not set the root password and not connect to localhost ??? the second is why when I set the machine name to jordan (root@jordan) does it tell me I am not logged in ? what do I need to do to sort this. Thanks, Matt Ps I think I have my head around the grant thing now. -Original Message- From: Count Schemula [mailto:[EMAIL PROTECTED]] Sent: 27 December 2001 13:01 To: [EMAIL PROTECTED] Subject: RE: Re: host not allowed to connect ? where is this config ? --- Matthew Darcy [EMAIL PROTECTED] wrote: can you explain how to do this as I keep struggling with users. Not sure on the root/password but I'd set one just in case. Users/grants drove me nuts too, here's some basic stuff: CREATE DATABASE whichdb USE whichdb GRANT ALL ON whichdb.* TO [EMAIL PROTECTED] IDENTIFIED BY somepassword note the .* wildcard in the above! some others: SHOW DATABASES; SHOW TABLES; SHOW TABLES FROM whichdb; SHOW COLUMNS FROM which_table; The docs at www.mysql.com have this in there. It's abstract, and then it works! __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.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
a refresher mail
Hi, a week or so ago I requested some info on mysql gui's. I got some great info and feedback. The PHP admin tool seems to be one of the most popular. As I was cleaning out my mailbox I deleted a lot of mails I shouldn't have. Can I have some good links for some linux gui's (pref tools or source code for gui kits no rpms or debs) and a good windows gui. Thanks, Matt. - 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
Comments Welcome
Is this the output you would expect from a correctly compiled and installed mysql system when running mysql_install_db Also where is the support-files this message speaks of, Thanks, Matt. [mysqldba@jordan bin]$ ./mysql_install_db Installing all prepared tables 011220 15:38:01 /usr/local/mysql/libexec/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h jordan.no-dns.co.uk -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/local/mysql/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com [mysqldba@jordan bin]$ [mysqldba@jordan bin]$ - 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
As plain as the nose on your face
I have set the root password for the mysql install. I have read the manual and want to make a new database. I ran mysql_install_db (see my other mail today) which seemed to do little, then did what the manual told me with [mysqldba@jordan bin]$ ./mysqladmin create bathjobs ./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'bathjobs'' [mysqldba@jordan bin]$ why is this happening ? I was expecting to get a blank shcema which I could create tables, grants etc. Thanks, Matt - 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: As plain as the nose on your face
Thank you for explaining. I did try mysqladmin --help. This gave me a list of commands and I understood what each did however the problem was I didn't understand why the error was occuring. I get the impression you last comment was a little condesending, please remember all people where new to mysql at some point. I personally am having trouble with is as I am very much used to oracle and I am struggling to drop my old methods and embrace new one. I do read the help and man pages and the manual but sometimes things can be a little missleading, more so when you are used to something meaning 1 thing and you find out it means another with mysql. Please bare with me if I am slow on the uptake as I have tried to explain I am struggling to get my head around the basics. Thanks, Matt. -Original Message- From: James Cox [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 16:40 To: [EMAIL PROTECTED] Cc: Mysql Subject: RE: As plain as the nose on your face try ./mysqladmin -u root -p create bathjobs and FYI, ./mysqladmin --help Thank you. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 03:38 PM To: [EMAIL PROTECTED] Subject: As plain as the nose on your face I have set the root password for the mysql install. I have read the manual and want to make a new database. I ran mysql_install_db (see my other mail today) which seemed to do little, then did what the manual told me with [mysqldba@jordan bin]$ ./mysqladmin create bathjobs ./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'bathjobs'' [mysqldba@jordan bin]$ why is this happening ? I was expecting to get a blank shcema which I could create tables, grants etc. Thanks, Matt - 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 - 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: Reset MySQL Root password
use rpm -Uvh --force $PACKAGE -Original Message- From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] Sent: 18 December 2001 22:35 To: 'MySQL' Subject: Reset MySQL Root password Well it seems as though i may have mistyped my root password for mysql since nothing seems be working. Anybody no how to set a new root password or how to reset the old password in mysql? Already tried uninstalling the RPM from in hopes to redo the install but when i try it tells me the package hasn't been installed. odd. When i try to install (reinstall) the RPM it tells me the package cannot install because it is already installed. Grrr. JJ - 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: Reset MySQL Root password
or rpm -e $PACKAGE then re-install. -Original Message- From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] Sent: 18 December 2001 22:35 To: 'MySQL' Subject: Reset MySQL Root password Well it seems as though i may have mistyped my root password for mysql since nothing seems be working. Anybody no how to set a new root password or how to reset the old password in mysql? Already tried uninstalling the RPM from in hopes to redo the install but when i try it tells me the package hasn't been installed. odd. When i try to install (reinstall) the RPM it tells me the package cannot install because it is already installed. Grrr. JJ - 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: Reset MySQL Root password
On Wednesday 19 December 2001 12:27 pm, Matthew Darcy wrote: Hi, I am having this exact error message. I have not used mysql before and I mailed this question before and someone answered but it didn't work. I have compiled and installed mysql. I run the mysql_install_db script and it tells me to change my password. I have never set a password as this is the first time I am running it. I was told to NOT use the -p option which I did and it prompts me for a password I enter it and I get the not authorised use @ localhost message. what is the exact command line used to set the intial password. Thanks, Matt. On Wednesday 19 December 2001 11:24 am, Henning Sprang wrote: Am 18 Dec 2001 16:11:18 -0800 schrieb Jeremiah Jester: Went through these steps and resetup the tables but im still unable to set a new password. The command i used was: /usr/bin/mysqladmin -u root -p password mypassword I then was prompted for a password. But when it failed to authenticate I recieved this error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Yes, that's correct like this. I assume now that you want to set your initial password on the databse as you didn't already set one. You did not set any password until now and you cleaned up all your mysql Data before, dealing with a complete clean Mysql INstallation for now. That means you will have to use mysqadmin _without_ the -p option, as this option means for the user given with -u exists a password and I want to be prompted for this _actual_ password. The password keyword then means that you want to set the _new_ password for the user given with -u to the word after the keyword password. So, for now you have to type: mysqladmin -u root password YOURNEWPASSWORD after that when you want to change it againg, you will have to type mysqladmin -u root -p password MYSECONDNEWPASSWORD you will then be asked to type your old password one last time, then it will be changed to MYSECONDNEWPASSWORD. Sorry, some of my answers where a bit confusing in this thread! And OT: the last mail that came from me through the list shouldn't normally be sent out, I am just betatesting Ximian Evolution Mailer, and it really fucking sucks, at least the Version that come with Suse 7.3 - sending mail you don't want to be sent and not sending mail you consider beeing sent since long time is not considered a feature! henning - 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: Reset MySQL Root password
Hi, I am having this exact error message. I have not used mysql before and I mailed this question before and someone answered but it didn't work. I have compiled and installed mysql. I run the mysql_install_db script and it tells me to change my password. I have never set a password as this is the first time I am running it. I was told to NOT use the -p option which I did and it prompts me for a password I enter it and I get the not authorised use @ localhost message. what is the exact command line used to set the intial password. Thanks, Matt. On Wednesday 19 December 2001 11:24 am, Henning Sprang wrote: Am 18 Dec 2001 16:11:18 -0800 schrieb Jeremiah Jester: Went through these steps and resetup the tables but im still unable to set a new password. The command i used was: /usr/bin/mysqladmin -u root -p password mypassword I then was prompted for a password. But when it failed to authenticate I recieved this error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Yes, that's correct like this. I assume now that you want to set your initial password on the databse as you didn't already set one. You did not set any password until now and you cleaned up all your mysql Data before, dealing with a complete clean Mysql INstallation for now. That means you will have to use mysqadmin _without_ the -p option, as this option means for the user given with -u exists a password and I want to be prompted for this _actual_ password. The password keyword then means that you want to set the _new_ password for the user given with -u to the word after the keyword password. So, for now you have to type: mysqladmin -u root password YOURNEWPASSWORD after that when you want to change it againg, you will have to type mysqladmin -u root -p password MYSECONDNEWPASSWORD you will then be asked to type your old password one last time, then it will be changed to MYSECONDNEWPASSWORD. Sorry, some of my answers where a bit confusing in this thread! And OT: the last mail that came from me through the list shouldn't normally be sent out, I am just betatesting Ximian Evolution Mailer, and it really fucking sucks, at least the Version that come with Suse 7.3 - sending mail you don't want to be sent and not sending mail you consider beeing sent since long time is not considered a feature! henning - 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
getting there.....slowly
Ok the password problem is sorted just to make sure i am right the command I used was ./mysqladmin -u root password $password I have just ran mysql_install_db which didn't seem to do much except remind me to change me password. I have done a mysqladmin create test1 I then get the error that I do not have permission for localhost. 1.) how do I set up users ? 2.) how can I start creating my database and get on with some work ? thanks, Matt. - 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
Gui's for linux
Hi, I am not normally a fan of gui's but seeing as I am finding mysql a bit different from oracle I could use all the help I can get as my database may end up quite complicated. Are the gui's available for linux ??? are they any good. Thanks, Matt. - 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
some simple problems with 1 line answeres please help.
I have compiled and installed mysql on redhat 7.1 I am having a few problems. 1.) I compiled and installed as root then changed the ownership to the dba account. Will this cause any problems down the line. 2.) Is there s startup and shutdown script to put in /etc/rc.d/init.d or do I have to write my own ? 3.) I su to the dba account and want to a set the superuser password (for the mysql install not the OS) how can I do this. 4.) I su to the dba account and try to do anything I get eg: [mysqldba@jordan bin]$ ./mysqladmin create bathjobs ./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'bathjobs'' thanks in advance. PS I am finding this list a great help. - 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
cannot connect local.
Hi, I have compiled and installed as root mysql succesfully. I gave ownership of the install to my dba account and group. when I do a mysql connect local as the dba account I get a permission denied. Why is this and where are the actual tables and data held. Thanks, Matt. - 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: A News Group Perhaps.
Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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
I must be mental but.
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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: Mysql in NFS
I have done oracle on NFS and it is not really the best option due to NFS locking. ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you are using automount maps) dies this will hold your development/production up no end. Also oracle's table locking (not sure if mysql has this) causes problems over NFS. The only time I have seen it work ok was on a veritas cluster using the Oracle/NFS export as a failover and it worked BAD the machine failed over quite a few times and picked up but the machines had to be very powerfull as there was tons of rollbacks and non commited transactions, and non bound variables over NFS was s slow. I am sure you could do it but it is not wise. I have stored Oracle binarys on NFS so that clients could access oracle and manage it over NFS but never had good performance keeping the data on NFS. Matt. -Original Message- From: Shen, Lei (CIT) [mailto:[EMAIL PROTECTED]] Sent: 12 December 2001 14:28 To: [EMAIL PROTECTED] Subject: Mysql in NFS Hi! Dose anyone has a experience to building mysql database in network files system? and php? can you get me some information? thank you -Original Message- From: Marek Kustka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Embedded MySQL server the outside world Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - 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 - 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: I must be mental but.
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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: Problems compiling under Solaris 2.6
Hmmm, Good thinking. However, the files needed (autoconf) is in /usr/local/bin - which is in my $PATH. a which shows autoconf so I know it can be seen without any problems. There is no ld.conf.so under solaris 2.6. Any more suggestions as I am having big problems with this. Thanks, Matt. -Original Message- From: Alan W. Rateliff, II [mailto:[EMAIL PROTECTED]] Sent: 05 December 2001 15:15 To: Matthew Darcy Subject: Re: Problems compiling under Solaris 2.6 On 05-Dec-01, Matthew Darcy said something totally profound about Problems compiling under Solaris 2.6 that made me ponder... MD MD Hi, MD MD I am running fully patched Solaris 2.6 on a Sun ultra 2 server. MD MD I am running a simple MD MD ./configure --enable-thread-safe-client --with-mysqld-user=dba MD MD and yes the dba account exists. MD MD There is 2 problems with this. MD MD 1.) if you examine the output of configure you will notice the it cannot MD find autoconf - although if you view pkginfo output you will notice that MD autoconf is present and in the search path. Why is this and how to fix ? Make sure that these packages are in your PATH. MOST SMC packages install in /usr/local, so having /usr/local/bin in your PATH should be sufficient. MD 2.) if you read the end of the configure output you will notice an error. MD I am unsure what this error means, and the librarys that it complains MD COULD be missing are infact installed in the correct place. Make sure that ALL of your library directories are in your LD_LIBRARY_PATH, or listed in /etc/ld.so.conf. I'm not sure it /etc/ld.so.conf exists in Solaris 2.6 or not, as that majority of my work has been in Solaris 8. However, I have had successfull compiles under 2.4, 2.5.1, 2.6, 7, and 8. -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.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