Re: New to MySQL
Hi, Thank you for your help and nice tutorials An easy for installation is here: Thanks Andrew http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-centos Here is another link http://opensourcedbms.com/dbms/installing-mysql-5-6-on-cent-os-6-3-redhat-el6-fedora/ I have read few articles and will install using yum installation but before that i would like to fix the error, I checked what is installed already rpm -qa | grep -i mysql MySQL-client-5.6.16-1.el6.x86_64 mysql-libs-5.1.69-1.el6_4.x86_64 ** MySQL-client-5.6.16-1.el6.x86_64 I have installed before and got the error file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 mysql-libs-5.1.69-1.el6_4.x86_64 Already in CentOS So mysql server is not installed and no mysqld in /etc/init.d/ Shall i remove mysql client and re install client and server 5.1 to fix the error yum remove mysql mysql-* or update mysql 5.1 and install mysql server and client 5.6 Thank you very much in advance. Best Regards, Rabe On Thu, Mar 6, 2014 at 4:44 AM, Brian Van der Westhuizen [DATACOM] brian.vanderwesthui...@datacom.co.nz wrote: Asma, I think maybe it is a good idea if you start reading Mysql for dummies or something similar. If you do not understand the basic concepts of unix/linux and mysql, I see a hard road for you. Google is you friend and I believe they would even have documentation in your native language. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Thursday, 6 March 2014 12:08 a.m. To: Andrew Moore Cc: Reindl Harald; mysql@lists.mysql.com Subject: Re: New to MySQL How to do that? Thank you On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore eroomy...@gmail.com wrote: Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail
Re: New to MySQL
How to do that? Thank you On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore eroomy...@gmail.com wrote: Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail
Re: New to MySQL
Thank you very much for responding. I have checked before installation if mysql is installed using which mysql ,i found no mysql is installed. next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) Any idea? Thank you all for your kind help Rabe On Tue, Mar 4, 2014 at 12:30 AM, geetanjali mehra mailtogeetanj...@gmail.com wrote: Thanks for responding. MySQL installation ,here, do not require mysql-libs package. As far as I know, there is no harm on using this command. I too got the same problem, and I didn't face any problem after removing this package. This package is installed by default and not needed here. So, this command is very safe. On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Re: New to MySQL use rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem with the packages or if you simply don't need the -libs package when installing the server. I would, however, suggest using Rug, Zypper or a similar advanced package manager instead of barebones RPM, as those will actually find and install any necessary dependencies, too. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi
Install mysql server using RPM
Hi all, I am trying installing Mysql server using RPM bundle rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm rpm -i MySQL-client-5.6.16-1.el6.x86_64.rpm next i would like to start the server, i followed the mysql docs: The server RPM places data under the /var/lib/mysql directory. The RPM also creates a login account for a user named mysql (if one does not exist) to use for running the MySQL server, and creates the appropriate entries in /etc/init.d/ to start the server automatically at boot time. (This means that if you have performed a previous installation and have made changes to its startup script, you may want to make a copy of the script so that you do not lose it when you install a newer RPM. when i checked /var/lib i found non for mysql,Any idea?? Thank you very much in advance. Best Regards, Rabe
Re: New to MySQL
I installed my sql using RPM as follows: rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 When i tested if the server has installed or not bin/mysqlshow -bash: bin/mysqlshow: No such file or directory Any help is appreciated . Best Regards, Rabe On Fri, Feb 28, 2014 at 1:36 AM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: Asma rabe asma.r...@gmail.com Subject: Re: New to MySQL so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? The Server should suffice; the Bundle is merely a convenient way to download ALL the RPMs in one go. -- Unhappiness is discouraged and will be corrected with kitten pictures.
New to MySQL
Hi, I would like t install MySQL server on Linux and MYSQL client and GUI may be workbench on client machine. For server installation, I found several options for download, I would appreciate if anyone can tell me which is better to install *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageMySQL Server* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageCompatibility Libraries* *Thank you very much in advance* *Best Regards,* *Rabe*
Re: New to MySQL
Thank you very much Iqbal ,Johan, Actually I have Linux redhat already installed so I have to install MySQL server and client. so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? Thank you very much. Rabe On Fri, Feb 28, 2014 at 12:50 AM, Iqbal Aroussi iq...@aroussi.ca wrote: Hi Asma, If you are new to MySQL and/or Linux. Start with Ubuntu + MySQL. Best Regards Iqbal Aroussi 514 451-9122 On Thu, Feb 27, 2014 at 10:43 AM, Asma rabe asma.r...@gmail.com wrote: Hi, I would like t install MySQL server on Linux and MYSQL client and GUI may be workbench on client machine. For server installation, I found several options for download, I would appreciate if anyone can tell me which is better to install *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageMySQL Server* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageCompatibility Libraries* *Thank you very much in advance* *Best Regards,* *Rabe*