Can I Develop using Community Edition and Deploy onto Enterprise Edition??
Hi Please I need some advice. We are in the process of upgrading from the Free Community Edition of MySQL on our Live environment to the Enterprise Edition. Do we need to do the same for my Development environment or can I continue developing on the Community Ed and then simply deploy any code, SQL script, etc to the Live Enterprise edition on our live server? All advice and pointers welcome. Thank you Regards Alastair Armstrong Development Manager Vox Orion (Pty) Ltd 19 Tambach Road Sunninghill Johannesburg Tel:+27 11 808 1000 Direct:+27 11 808 1208 Mobile: +27 83 323 1333 Fax: +27 86 556 8411 Email: alasta...@voxorion.co.za mailto:alasta...@voxorion.co.za Web: www.voxorion.co.za http://www.voxorion.co.za/ This e-mail is intended only for the person to whom it is addressed and may contain confidential information which may be legally privileged. If it has been sent to you in error ,this serves to advise you that you may not forward ,copy, print or use this e-mail or any attachments in any manner or form. You are also requested to please advise the sender immediately by e-mail or by telephone and then to delete this e-mail. Vox Orion accepts no liability for any loss, expense or damage arising from this e-mail and/or any attachments.
new host access to database
Can someone please tell me what the command would look like to grant access for the root user to a database and table on a remote host. Thanks in advance -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 27 October 2005 23:12 To: mysql@lists.mysql.com Subject: Re: Slave Problem Hello. Do you have your Slave is still trying to reconnect? If yes, are you sure that you don't have network problems? I have a script checking for when the replication fails but that does not include this type problem. Is this a bug in replication or do I need to update my script to check for this ? Replication fails sometimes. I haven't found similar bug, but if you able perform an upgrade to the latest release. Often it helps. If you want to debug the problem make a research of the binary logs to find out the weird even, which causes Slave to reconnect. See: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html Marvin Wright wrote: Hi, I found this morning that the slave replication thread seem to have hung. Below I have pasted in my show slave status, it seems to be stuck trying to connect to the master. To fix this I issued a stop slave and start slave, my slave is about 3 weeks behind now. I have a script checking for when the replication fails but that does not include this type problem. Is this a bug in replication or do I need to update my script to check for this ? I'm running version 4.1.12 on Redhat AS3. Many Thanks Marvin. mysql show slave status\G *** 1. row *** Slave_IO_State: Reconnecting after a failed master event read Master_Host: prdmysql01.prd.lastminute.com Master_User: web Master_Port: 3306 Connect_Retry: 60 Master_Log_File: prdmysql01-bin.000118 Read_Master_Log_Pos: 15561995 Relay_Log_File: prdmysql02-relay-bin.01 Relay_Log_Pos: 80882143 Relay_Master_Log_File: prdmysql01-bin.000118 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 15561995 Relay_Log_Space: 80882143 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL 1 row in set (0.00 sec) ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Visit our websites: http://www.dailysnack.com “bite size news and gossip” http://www.express.co.uk The Worlds Greatest Newspaper http://www.dailystar.co.uk Simply The Best 7 Days A Week http://www.happymagazine.co.uk The One Stop Shopping Magazine http://www.ok.co.uk First For Celebrity News http://www.northernandshell.co.uk The Mark Of Excellence http://www.expresspictures.com Express Newspapers and OK Magazine online picture archive Also visit: The NMA: Opening Up Newspapers http://www.nmauk.co.uk ###2004### Any views or opinions are solely those of the author and do not necessarily represent those of Express Newspapers The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.If you are not the intended recipient of this message please do not read ,copy, use or disclose this communication and notify the sender immediately. It should be noted that any review, retransmission, dissemination or other use of, or taking
RE: PHP and mysql
Thanks for your reply I think this is the issue I don't think root is allowed to login from local host I created another user called web user and changed the script, that works fine, next question is how do I set the permissions for root in mysql to allow root to login, if I use #mysql -u root password I go straight in If I use #mysql -u root -p password I get access denied for [EMAIL PROTECTED] -Original Message- Visit our websites: http://www.dailysnack.com “bite size news and gossip” http://www.express.co.uk The Worlds Greatest Newspaper http://www.dailystar.co.uk Simply The Best 7 Days A Week http://www.happymagazine.co.uk The One Stop Shopping Magazine http://www.ok.co.uk First For Celebrity News http://www.northernandshell.co.uk The Mark Of Excellence http://www.expresspictures.com Express Newspapers and OK Magazine online picture archive Also visit: The NMA: Opening Up Newspapers http://www.nmauk.co.uk ###2004### Any views or opinions are solely those of the author and do not necessarily represent those of Express Newspapers The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.If you are not the intended recipient of this message please do not read ,copy, use or disclose this communication and notify the sender immediately. It should be noted that any review, retransmission, dissemination or other use of, or taking action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. E-mail communications may be monitored. ##EXN2000## From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: 25 October 2005 18:06 To: Alastair Roy Cc: mysql@lists.mysql.com Subject: Re: PHP and mysql Yes. Whenever you have a problem, go back to basics. Can you login as root on the commandline? What password do you use there? Once you're there, check root's permissions, but I'd be willing to bet your password is incorrect, or root is only allowed to logon from localhost and not the machine the webserver is on. -Sheeri On 10/25/05, Alastair Roy [EMAIL PROTECTED] wrote: Greetings everyone, I am having a problem with PHP and mysql I have copied a script exactly off a website to open the database and insert a new user I try to access the mysql database using the root user, and enter information into the user table, this is the PHP I am using ? include 'library/config.php'; include 'library/opendb.php'; $query = INSERT INTO user (host, user, password, select_priv, insert_priv, update_ priv) . VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y', 'Y'); mysql_query($query) or die('Error, insert query failed'); $query = FLUSH PRIVILEGES; mysql_query($query) or die('Error, insert query failed'); include 'library/closedb.php'; ? When I try this I get the access for user [EMAIL PROTECTED] host denied, it is driving me nuts no matter what I try I get the same thing other scripts I have tried do the same thing, have tried messing around with the config.php and opendb.php included scripts but nothing works if I run php -f opendb.php I get no errors which I think means it is working, then again I don't know. Anyone have any ideas ?? Thanks in advance Visit our websites: http://www.dailysnack.com “bite size news and gossip” http://www.express.co.uk The Worlds Greatest Newspaper http://www.dailystar.co.uk Simply The Best 7 Days A Week http://www.happymagazine.co.uk The One Stop Shopping Magazine http://www.ok.co.uk First For Celebrity News http://www.northernandshell.co.uk The Mark Of Excellence http://www.expresspictures.com Express Newspapers and OK Magazine online picture archive Also visit: The NMA: Opening Up Newspapers http://www.nmauk.co.uk ###2004### Any views or opinions are solely those of the author and do not necessarily represent those of Express Newspapers The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.If you are not the intended recipient of this message please do not read ,copy, use or disclose this communication and notify the sender immediately. It should be noted that any review, retransmission, dissemination or other use of, or taking action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. E-mail communications may be monitored. ##EXN2000## -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL
PHP and mysql
Greetings everyone, I am having a problem with PHP and mysql I have copied a script exactly off a website to open the database and insert a new user I try to access the mysql database using the root user, and enter information into the user table, this is the PHP I am using ? include 'library/config.php'; include 'library/opendb.php'; $query = INSERT INTO user (host, user, password, select_priv, insert_priv, update_ priv) . VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y', 'Y'); mysql_query($query) or die('Error, insert query failed'); $query = FLUSH PRIVILEGES; mysql_query($query) or die('Error, insert query failed'); include 'library/closedb.php'; ? When I try this I get the access for user [EMAIL PROTECTED] host denied, it is driving me nuts no matter what I try I get the same thing other scripts I have tried do the same thing, have tried messing around with the config.php and opendb.php included scripts but nothing works if I run php -f opendb.php I get no errors which I think means it is working, then again I don't know. Anyone have any ideas ?? Thanks in advance Visit our websites: http://www.dailysnack.com “bite size news and gossip” http://www.express.co.uk The Worlds Greatest Newspaper http://www.dailystar.co.uk Simply The Best 7 Days A Week http://www.happymagazine.co.uk The One Stop Shopping Magazine http://www.ok.co.uk First For Celebrity News http://www.northernandshell.co.uk The Mark Of Excellence http://www.expresspictures.com Express Newspapers and OK Magazine online picture archive Also visit: The NMA: Opening Up Newspapers http://www.nmauk.co.uk ###2004### Any views or opinions are solely those of the author and do not necessarily represent those of Express Newspapers The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.If you are not the intended recipient of this message please do not read ,copy, use or disclose this communication and notify the sender immediately. It should be noted that any review, retransmission, dissemination or other use of, or taking action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. E-mail communications may be monitored. ##EXN2000##
Re: Setting net_buffer_length
On Fri, Feb 22, 2002 at 10:52:14AM +0100, Martin MOKREJ? wrote: Hi, we have 3.23.42 official binaries running on Linux 2.4.17. It seems mysqld does not read in from /etc/my.cnf the value for net_buffer_length. When having in the config file: [mysqld] set-variable= net_buffer_length=16M set-variable= max_allowed_packet=16M [...] I get | net_buffer_length | 1047552 | max_allowed_packet | 16776192 I'm using 3.23.36 on Linux and posted a question yesterday about configuration parsing, in particular the way MySQL seems to parse (or not) the my.cnf file (I can't get it to recognise a 'log=' line in my.cnf, to log elsewhere). I tried doing the same as you ... Before ; net_buffer_length | 16384 Add to /etc/my.cnf (in [mysqld] section) ; set-variable = net_buffer_length=3M After (stop/start server) ; net_buffer_length | 1047552 So ... at least in my version here there some difference being made. I was expecting a figure of roughly 3Mb and not 1Mb though! Something's flaky with configuration. Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.com | | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there a limit on the email size for this list?
On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote: I posted a question but received a message stating the file was to large? Look at the message. Some idiot's mailbox is over the limit. Anytime I post to this list I get 2 return mails bounced from lusers. With regards to your problem - 1) don't yopu really want to create a mysel user/group and use that as an arg to --user? 2) what are the exact permissions to your data dir? ls -l /usr/local ls -l /usr/local/mysql ls -l /usr/local/mysql/data Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.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
Logging problem with --log, my.cnf etc.
Hello, I am using MySQL 3.23.36 on Linux. This is a small gripe about a product I am otherwise very happy with. I hope I have not missed the obvious or been stupid some other way. The problem - I want to log somewhere other than $DATADIR. Things are set up like ; | log | ON | log_update | OFF | log_bin | OFF | log_slave_updates | OFF | I would have liked to use the my.cnf file to achieve this but it doesn't appear to work i.e. a line like (in the [mysqld] section) ; log=/var/log/mysql.log has no effect. Looking at 'mysqld --help' output would show this is set i.e. logfile: /var/log/mysql.log but this file is not created. In fact, logging appears to stop. So, I thought I would try adding the argument to my mysql init script - args that are passed to 'safe_mysqld' i.e. In /etc/init.d/mysql I added ; --log=/var/log/mysql.log to the command line for 'safe_mysqld'. But this too had no effect - no log file created, no logging. So ... I decided to look at 'safe_mysqld'. This is a much more complex program but, seemed to me, to be potentially ignoring a '--log' line i.e. In the 'case' statement near the top ; for arg do case $arg in # these get passed explicitly to mysqld --basedir=*) MY_BASEDIR_VERSION=`echo $arg | sed -e s;--basedir=;;` ;; --datadir=*) DATADIR=`echo $arg | sed -e s;--datadir=;;` ;; --pid-file=*) pid_file=`echo $arg | sed -e s;--pid-file=;;` ;; ... There is no catch for '--log', and I assume the catchall default ; *) if test -n $pick_args ... misses it as well (or it's ignored later ...). So ... I (probably badly) hacked this script a bit and now I have logging to /var/log/mysql.log. I was looking in some 'changelogs' and found no mention of problems. I also searched the list archives and found one other person with a similar problem which was never resolved ; http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:24135:lkonncgmkabnpiggbdio So, would someone take a look at this and see if they can figure out where the problem lies? I admit it might be me. Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.com | | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Logging problem with --log, my.cnf etc.
On Thu, Feb 21, 2002 at 01:02:02PM -0500, Luc Foisy wrote: Does mysql have permission to write to that location? Yes. I'm starting and stopping MySQL using an init script a la Redhat. This calls 'safe_mysqld' with some args (e.g. --user,--pid-file etc.) - all started as user root as usual. The problem is that I could not see the '--log' file getting recognised or used in safe_mysqld. As I said, I would much rather be using /etc/my.cnf with the log= syntax. What I did in 'safe_mysqld' was ; 1) Add --log=/var/log/mysql.log to the call to safe_mysqld in my mysql init script 2) Add --log=*)log=`echo $arg | sed -e s;--log=;;` ;; to the 'case' statement at the top. 3) After the USER_OPTION= block further down I added ; LOG_OPTION=--log=$log touch $log; chown $user $log 4) Added $LOG_OPTION to the actual call to $MYSQLD (x2) near the bottom. This is a production machine I am playing with here at work so I am limited in what I can screw around with. I need to re-test this stuff at home again. But - has anyone managed to change MySQL's log file using my.cnf and the log= syntax? Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.com | | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Logging problem with --log, my.cnf etc.
On Thu, Feb 21, 2002 at 01:47:50PM -0500, Luc Foisy wrote: maybe the variable you are using is not right my 'show variables' indicates log with a value of OFF | log | OFF yet mysql still generates its standard error file Hi Luc, Thanks for the reply (but please just reply to the list and not a CC - I've subscribed). I want 'LOG' to be 'ON' so I can log updates,selects etc. i.e. standard logging (-l,--log,--log=file). The stderr log (err_log) is of no relevance to me for this. Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.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