How can I obtain the corrosponding Signature file for a MySQL package to verify package
According to the Doc http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the Signature file for a MySQL package can be obtained from the download page.But I am not able to locate it? -- Kind Regards Varuna Seneviratna
Re: How can I obtain the corrosponding Signature file for a MySQL package to verify package
I want to know about veryfing the Signature not the Md5 as described in the page http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html.I did verify Md5 checksum. On 2 December 2010 22:51, viraj kali...@gmail.com wrote: http://dev.mysql.com/downloads/mysql/ you can see the md5 sum close to the download button ~viraj On Thu, Dec 2, 2010 at 7:48 PM, Varuna Seneviratna varunasenevira...@gmail.com wrote: According to the Doc http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the Signature file for a MySQL package can be obtained from the download page.But I am not able to locate it? -- Kind Regards Varuna Seneviratna -- Kind Regards Varuna Seneviratna
Re: How can I obtain the corrosponding Signature file for a MySQL package to verify package
Viraj! The problem is not the public key But getting the corresponding Key to the downloaded package as mentioned in the below extract from the MySQL 5.1 Manual http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html After you have downloaded and imported the public build key, download your desired MySQL package and the corresponding signature, which also is *available from the download page*. The signature file has the same name as the distribution file with an .asc extension, as shown by the examples in the following table. *The Signature file corresponding to the downloaded MySQL package is not to be found on the download page* On 2 December 2010 23:23, viraj kali...@gmail.com wrote: sorry for not reading it correctly.. yep.. seems like a good catch. .asc is not linked or available in keyserver for bu...@mysql.com. cut and paste the provided build key in the manual and gpg --import could be a solution ~viraj On Thu, Dec 2, 2010 at 10:58 PM, Varuna Seneviratna varunasenevira...@gmail.com wrote: I want to know about veryfing the Signature not the Md5 as described in the page http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html.I did verify Md5 checksum. On 2 December 2010 22:51, viraj kali...@gmail.com wrote: http://dev.mysql.com/downloads/mysql/ you can see the md5 sum close to the download button ~viraj On Thu, Dec 2, 2010 at 7:48 PM, Varuna Seneviratna varunasenevira...@gmail.com wrote: According to the Doc http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.htmlthe Signature file for a MySQL package can be obtained from the download page.But I am not able to locate it? -- Kind Regards Varuna Seneviratna -- Kind Regards Varuna Seneviratna -- Kind Regards Varuna Seneviratna
Re: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG?
Hello Brian! What do you mean!, Who do u intend by account manager.*I am using community server 5.1* On 3 December 2010 02:30, Brian Guy brian@oracle.com wrote: Hi Varuna, Sorry, I do not know the answer to this. Who is your account manager, and I can ask him/her to find out for you? If you do not know your account manager, please let me know your company name and location, and we can find out who your account manager is. Thanks, Brian [image: Oracle] http://www.oracle.com/ Brian Guy | MySQL Consulting Practice Manager, Americas Oracle MySQL Seattle, Washington USA [image: Green Oracle] http://www.oracle.com/commitmentOracle is committed to developing practices and products that help protect the environment On Dec 2, 2010, at 6:12 AM, Varuna Seneviratna wrote: Hi Brian I am contacting you according the mail I got from Brian Miezejewski I suppose, As you can see from the below reply I got after posting to the mailing list.My question is described below According to the Doc http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the Signature file for a MySQL package can be obtained from the download page.But I am not able to locate it? -- Forwarded message -- From: brian.miezejew...@oracle.com Date: 2 December 2010 19:34 Subject: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG? To: varuna.senevira...@gmail.com Hi, I am on Medical Leave. Please contact Brian Guy at brian@oracle.com in my absense. Cheers, Brian -- Kind Regards Varuna Seneviratna -- Kind Regards Varuna Seneviratna
Changing the location of my.ini and the order option files are read
I added a line to the [mysqld) group As --defaults-file=C:\WINDOWS\my.ini and then I restarted the service.Everything was fine.Then I took out the my.ini file in the MySQL instalation directory the result was an error message AS Could Not start the MySQL Service on Local Computer Error 1067 The preocess terminated unexpectedly According to the manual MySQL server reads option files in the order Default options are read from the following files in the given order: C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\MySQL Server 5.0\my.ini C:\Program Files\MySQL\MySQL Server 5.0\my.cnf To see the order I ran the command mysqld-nt --verbose --help If the optin files read order is as above why can,t get the service started Varuna
Re: Changing the location of my.ini and the order option files are read
Armin I did what you said, now I understand what you say that there is no sence in what I wanted to do.But I gave these commands as follows But it did not work.What I want is to specify a configuration file which is placed in the WINDOWS directory.The commands I ran C:\NET STOP MySQL C:\mysqld-nt --remove C:\mysqld-nt --install MYSQL --defaults-file=\c:\WINDOWS\my.ini\ Service successfully installed. C:\net start mysql System error 2 has occurred. The system cannot find the file specified. Why is the file not able to be found, I have taken my.ini out of the MySQL installation directory and placed it in the WINDOWS directory. Are there other commands to start a service apart from NET commands,like using mysqladmin? Varuna On Mon, Oct 6, 2008 at 7:07 PM, Armin Schöffmann [EMAIL PROTECTED] wrote: Varuna, obviously it doesn't make much sense, to specify the my.ini location in my.ini itself. The --defaults-file option is used as a direct start-up parameter for mysql-server both, run as service or console-process. It simply tells the server-process where to look for the oneandonly my.ini. Any fullpath given here, overrides the default search-path during server-startup. I assume your server-process has been already started with a --defaults-file -option pointing to a my.ini in the mysql-application-directory, therefor it failed after deleting the file at this location. You may change the direct service-startup options by invoking mysqld-nt with options --remove and --install: With the install option you can specify the complete command-line including additional options which will be used when the server starts as a service. e.g. net stop mysql mysqld-nt --remove mysqld-nt --install MYSQL --defaults-file=\c:\program files(x86)\mysql\my.ini\ net start mysql Regards, Armin. 2008/10/6 Varuna Seneviratna [EMAIL PROTECTED]: I added a line to the [mysqld) group As --defaults-file=C:\WINDOWS\my.ini and then I restarted the service.Everything was fine.Then I took out the my.ini file in the MySQL instalation directory the result was an error message AS Could Not start the MySQL Service on Local Computer Error 1067 The preocess terminated unexpectedly According to the manual MySQL server reads option files in the order Default options are read from the following files in the given order: C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MySQL\MySQL Server 5.0\my.ini C:\Program Files\MySQL\MySQL Server 5.0\my.cnf To see the order I ran the command mysqld-nt --verbose --help If the optin files read order is as above why can,t get the service started Varuna -- Aegaeon technologies GmbH phone: +49.941.8107344 fax: +49.941.8107356 Legal disclaimer: http://aegaeon.de/disclaimer/email_all_int.txt
Re: mysqld, mysqld-nt, mysqld-debug
Hello Steven I have installed it as an service, I first stopped the service form the Service Control Manager and I went to the directory C:\Program Files\MySQL\MySQL Server 5.0\bin ran the command mysqld --console. and out put was C:\Program Files\MySQL\MySQL Server 5.0\binmysqld --console 'mysqld' is not recognized as an internal or external command, operable program or batch file. The reference manual says that there are three server types, mysqld ,mysqld-nt, mysqld-debug.My problem is I am able to start mysqld server Varuna On Sun, Oct 5, 2008 at 1:14 PM, Steven [EMAIL PROTECTED] wrote: Good Morning Steven Hello Varuna! Well to start mysqld the reference manual instructs to give the command [C:\ C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console] The out put is as below 'C:\' is not recognized as an internal or external command, operable program or batch file.under the heading Starting the server for the first time It's not practical to install MySQL in the directory Program Files, because the folder name for cmd is too long and it's a little bit tricky. Better structure is the following: C:\MySQL\ So the service to start - Command Prompt (cmd) C: cd /MySQL/ mysqld-- console It is important to the folder where MySQL is. Otherwise it is not my opinion. Greetings, Steven
Re: mysqld, mysqld-nt, mysqld-debug
Andy! Even Installing as a service and choosing Server Machine as Server type does not install mysqld the settings I used are as follows. I even did a search in the C drive SetUp Type Complete The configuration choices made running Configuration Wizard 1Configuration Type Detailed 2 Server Type Server Machine 3 Database Usage Transactional database only 4 Drive for InnoDB data file InnoDB Tablespace Settings Default Settings(C: Drive and Installation path) 5 Number OF Concurrent Approximate connections Decision Support 6 Networking Options Enable networking options Checked(ticked) Add firewall exception for port 3306 Checked(ticked) Enable strict mode Checked(ticked) 7 Default Charter set Standard Character set 8 Windows Options Install As A Service Checked(ticked) Launch MySQL Server Automaticaly Checked(ticked) Service Name: MySQL Include Bin Directory in Windows path Checked(ticked) 9 Set the security settings A root password set 10 Ready to Execute Screen Execute Button Clicked Preparation configuration Okay Write Configuration file (C:\Program Files\MySQL\MySQL Server 5.0\bin) Okay Start Service Okay Apply security settings Okay Regards Varuna On Sun, Oct 5, 2008 at 9:05 PM, Andy Shellam [EMAIL PROTECTED]wrote: Varuna, Please also remember to copy the list back in to your response so others can follow your steps if they're having trouble. As I said in my e-mail, I would recommend installing as a Windows service (you said in your e-mail that Install as a Windows service was unchecked.) I don't use MySQL on Windows so I cannot be 100% confident, but this might be the reason why the mysqld binary is not installed. You could also try installing the server as a Server Machine, not a Developer Machine. Try these and see if you get any further. Regards, Andy Varuna Seneviratna wrote: Dear Andy I am sorry if I have been nuisance to you by posting six times the same question.I wanted to learn all the three types of the server. I did a search as you have suggested and it didn't return a mysqld binary.But it returned mysqld-nt.What the reference manual says is not true.I again installed and i have listed them below .I have tried choosing the setup type as complete and custom also But the mysqld server can not be started The setUp double clicked and the screen to select the setup type appeared Then as follows 1 SetUp type typical Configuration Wizard 1 Server Type Developer Machine 2 Database Usage Multifunctional Database 3 InnoDB data file drive the default settings was selected Drive C and the installation path 4 Approximate Number Of Connections Decision Support(Dss and OLAP) 5 Networking Options TCP/IP Enabled port number 3306, Add Firewall Exception checked Enabled Strict Mode checked 6 Default character set Standard Character set 7 Windows Options Install as a Windows serviceUnchecked Include Bin Directory in Windows Path Checked *The screen with the execute Button Appeared and When clicked Prepare configuration ticked(Okay) Write Configuration file path(C:\Program Files\MySQL\MySQL Server 5.0\my.ini) ticked(Okay) After above listed installation I went to the bin directory and typed mysqld --console-Nothing happened mysqld-nt --console The output was 081005 19:02:09 InnoDB: Started; log sequence number 0 43655 081005 19:02:09 [Note] mysqld-nt: ready for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) Anyway I will settle with the mysqld-nt and go on with my assignment.Thanks For your help.Iam sorry if I have caused you any inconvenience Thanks Regards Varuna On Sun, Oct 5, 2008 at 3:17 PM, Andy Shellam [EMAIL PROTECTED] wrote: Varuna, A polite note - if you post the same question 6 times (especially in the space of 24 hours) people are going to be more unlikely to help you. Post the question once, and read people's responses. Now onto your issues... When you run mysqld-nt you were starting a standalone version of MySQL with named pipes support. Once this was running in one command window, you would need another command window with a client connecting to that server. The message you are getting back from Windows is that mysqld doesn't exist in C:\Program Files\MySQL\MySQL Server 5.0\bin. My first step would be to do a search for this binary (Start Search Files or Folders etc.) Secondly there are a number of ways in which MySQL can be installed on a Windows system - how did you do it? Which package did you download? Have you run the configuration wizard? (I don't use MySQL
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna
Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
Hi Ian Thanks! Your advice worked.I have another problem.I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console But it didn't work, the following was the displayed message 'C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld' is not recognized as an i nternal or external command, operable program or batch file. *But when I used mysqld-nt The following is the out put* C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --console 081004 16:56:01 InnoDB: Started; log sequence number 0 43655 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were used; s o replication may break when this MySQL server acts as a slave and has his hostn ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid this p roblem. 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: re ady for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 After starting the server in above mentioned way How can I use MySQL server Do I have to open another console window and do what? Thanks Varuna On Sat, Oct 4, 2008 at 2:19 PM, Ian Simpson [EMAIL PROTECTED] wrote: Hi Varuna, The problem looks like it is with the command you issued. The correct syntax is: mysqladmin -uroot -p shutdown then supply root password. Without giving the -uroot argument, it doesn't know that you are trying to log in as the root user, which is why it is telling you that access is denied for [EMAIL PROTECTED], rather than [EMAIL PROTECTED] Thanks On Sat, 2008-10-04 at 13:56 +0530, Varuna Seneviratna wrote: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for the password? I have Nortan Internet Security trial version running and the windows firewall is disabled.If this is caused by a firewall barrier please tell me how to open the port in Nortan Internet Security. Varuna -- Ian Simpson System Administrator MyJobGroup
How to start mysqld server, What is the difference between a server and a server?
Hello Every body! I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console But it didn't work, the following was the displayed message 'C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld' is not recognized as an i nternal or external command, operable program or batch file. *But when I used mysqld-nt The following is the out put* C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --console 081004 16:56:01 InnoDB: Started; log sequence number 0 43655 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were used; s o replication may break when this MySQL server acts as a slave and has his hostn ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid this p roblem. 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: re ady for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 After starting the server in above mentioned way How can I use MySQL server Do I have to open another console window and do what? 4 In Windows is it not possible to start other to two servers mysqld and mysqld-debug Thanks Varuna
What is the user account's password, Why is most of the things in the reference manual does not work as stated?
What is the user account's password.I used the command C:\mysql -u user -p Enter password: ** ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: Y ES) How can I find it? Varuna
Please the whole message?
I have WindowsXP I stopped the service from the services shortcut in the Administrative tools.then according to to the reference manual to start the server for the first time the command to run is given as C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console But it didn't work, the following was the displayed message 'C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld' is not recognized as an i nternal or external command, operable program or batch file. *But when I used mysqld-nt The following is the out put* C:\C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt --console 081004 16:56:01 InnoDB: Started; log sequence number 0 43655 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were used; s o replication may break when this MySQL server acts as a slave and has his hostn ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid this p roblem. 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: re ady for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 After starting the server in above mentioned way How can I use MySQL server Do I have to open another console window and do what? 4 In Windows is it not possible to start other to two servers mysqld and mysqld-debug Varuna
server mysqld how to start in WindowsXP
Why can't I start mysqld server on WindowsXp, The reference manula for 5.0 says that there are three servber types.But I am able to start only on mysqld, and only mysqld-nt gets installed.Am I doing something wrong? Varuna
mysqld, mysqld-nt, mysqld-debug
Hello Everybody 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 In Windows is it not possible to start other to two servers mysqld and mysqld-debug Varuna