Re: MySQL installation problems.
Hello. Is this a clean new install of MySQL, or you have already installed MySQL instance? Please provide more information about your OS version (I guess it is Windows, isn't it?). May be some tips from the manual could be helpful: http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html Kevin Pollard wrote: > Today I downloaded and installed MySQL 5.0 (the "Complete Package"). > > Everything seemed to go with the install until it got to the "Processing > configuration..." stage. > It successfully completed "Prepare configuration", and "Write > configuration file", and "Start service". > > But it failed when it got to "Apply security settings" with the error > message "The security settings could not be applied. Error number 2003. > Can't connect ot MySQL server on 'locahost' (10061) > > What can I do about that? > > > Kevin > > > -- 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]
MySQL installation problems.
Today I downloaded and installed MySQL 5.0 (the "Complete Package"). Everything seemed to go with the install until it got to the "Processing configuration..." stage. It successfully completed "Prepare configuration", and "Write configuration file", and "Start service". But it failed when it got to "Apply security settings" with the error message "The security settings could not be applied. Error number 2003. Can't connect ot MySQL server on 'locahost' (10061) What can I do about that? Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql installation problems (RPM errors)
First off to maybe make this easy on you, you do not need the MySQL-bench rpm if you do not plan on using the benchmarking tools. It is an optional install. Otherwise, I do not think rpm cares about capitalization. I believe this problem is discussed in the MySQL manual, and might have the solution, but then I am sure others on this list can help out. Most important thing to remember, is that you don't need benchmarking to run the MySQL server. In the past, I always used a tarball of the perl DBI and it worked fine. Gale Stafford wrote: Hey Folks Hi there! My first post to the list ... I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL server software, client software, but when I try to install the MySQL-bench...rpm, I get the failed dependencies error, MySQL-DBI-perl-bin is needed. I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies error. Is this a problem caused by "Mysql-DBI-perl...rpm) not having capitals in all the right places? I dont understand enough about how rpm works, to troubleshoot this! Can anyone help point me to the right MySQL-DBI-perl...rpm file? thanks, Gale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql installation problems (RPM errors)
Hey Folks Hi there! My first post to the list ... I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL server software, client software, but when I try to install the MySQL-bench...rpm, I get the failed dependencies error, MySQL-DBI-perl-bin is needed. I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies error. Is this a problem caused by "Mysql-DBI-perl...rpm) not having capitals in all the right places? I dont understand enough about how rpm works, to troubleshoot this! Can anyone help point me to the right MySQL-DBI-perl...rpm file? thanks, Gale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie MySQL installation problems (specific)
Ah...give up not for we have been using mysql for quite a long time and it
is pretty stable. Try this...
instead of trouble shooting this install and getting it work...
go to www.mysql.com, download an rpm if you are on Red hat linux (or
Mandrake) and do an
rpm -i mysql...rpm and
rpm -i mysq..client..rpm (this file is for insalling the client).
If not, just download the binary and follow the instructions. We haven't had
any trouble at all installing mysql and this might be a system specific
problem. Let me know how it works out.
Regards,
Bhavin.
- Original Message -
From: "Colin Cooler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 09, 2002 6:42 PM
Subject: Re: Newbie MySQL installation problems (specific)
> Thanks Bhavin,
>
> I tried your suggestion ("safe_mysqld start") and get a lot of "Permission
> denied" errors. So, I "su" to root and try it, and it appears that it
does
> start ("Starting mysqld daemon with databases from
/usr/local/mysql/data").
>
> However, when I try to connect, either as root (which I understand is not
a
> good idea) or under my normal login, I get the same error, i.e., that the
> socket can't be found.
>
> Very puzzling and I'm quickly approaching the point of concluding that the
> amount of time trying to troubleshoot this mess not warranting the
potential
> benefits.
>
> Colin
>
> > Have you tried .../bin/safe_mysqld start to start the DB first? This is
what
> > will create /tmp/mysql.sock socket file & start the DB server. Then you
can
> > use the 'mysql' client for connecting to the DB. Also, if you don't want
to
> > use transactional database, meaning, if you don't want support for
rollback
> > and stuff, which I am guessing you might not, then you can download the
> > 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc
> > Liyanage's site). Since it's giving errors regarding innodb, my guess is
> > that the server is configured to create inno db tables and not myisam
> > tables, which is what the default binaries/rpm are configured to do
(i.e.
> > create myisam tables, but they are non-transactional).
> >
> > Regards,
> > Bhavin.
> >
> > - Original Message -
> > From: "Colin Cooler" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, June 09, 2002 3:55 PM
> > Subject: Newbie MySQL installation problems (specific)
> >
> >
> >> Buying Paul DuBois' most excellent book "MySQL" has made me more
> > comfortable
> >> with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as
> > the
> >> web database for a redesigneed site at Right Moves For Youth (trying to
> > keep
> >> "at risk" kids in school).
> >>
> >> After running his "cleanup instructions" and then downloading and
> > installing
> >> the mysql package from Marc Liyanage's site, I tried to run the
following
> >> command (as per instructions):
> >> "sudo ./scripts/mysql_install_db;" I then get the following results:
> >>
> >>> Preparing db table
> >>> Preparing host table
> >>> Preparing user table
> >>> Preparing func table
> >>> Preparing tables_priv table
> >>> Preparing columns_priv table
> >>> Installing all prepared tables
> >>> ERROR: 1062 Duplicate entry 'localhost-root' for key 1
> >>> ERROR: 1062 Duplicate entry 'localhost-root' for key 1
> >>> 020609 0:35:05 ./bin/mysqld: Shutdown Complete
> >>
> >>
> >> When I try to start mysql from the command line, I then get the
ubiquitous
> >> error message: "ERROR 2002: Can't connect to local MySQL server
through
> >> socket '/tmp/mysql.sock' (2) "
> >>
> >> I also discovered a "localhost.err" file in my data directory which
yields
> >> the following information:
> >>
> >>> 020609 01:09:50 mysqld started
> >>> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
> >>> If you do not want to use transactional InnoDB tables, add a line
> > skip-innodb
> >>> to the [mysqld] section of init parameters in your my.cnf
> >>> or my.ini. If you want to use InnoDB tables, add for example,
> >>> innodb_data_file_path = ibdata1:30M
> >>> But to get good performance you should adjust for your hardware
> >>> the InnoDB startup options listed in section 2 at
&
Re: Newbie MySQL installation problems (specific)
Thanks Bhavin,
I tried your suggestion ("safe_mysqld start") and get a lot of "Permission
denied" errors. So, I "su" to root and try it, and it appears that it does
start ("Starting mysqld daemon with databases from /usr/local/mysql/data").
However, when I try to connect, either as root (which I understand is not a
good idea) or under my normal login, I get the same error, i.e., that the
socket can't be found.
Very puzzling and I'm quickly approaching the point of concluding that the
amount of time trying to troubleshoot this mess not warranting the potential
benefits.
Colin
> Have you tried .../bin/safe_mysqld start to start the DB first? This is what
> will create /tmp/mysql.sock socket file & start the DB server. Then you can
> use the 'mysql' client for connecting to the DB. Also, if you don't want to
> use transactional database, meaning, if you don't want support for rollback
> and stuff, which I am guessing you might not, then you can download the
> 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc
> Liyanage's site). Since it's giving errors regarding innodb, my guess is
> that the server is configured to create inno db tables and not myisam
> tables, which is what the default binaries/rpm are configured to do (i.e.
> create myisam tables, but they are non-transactional).
>
> Regards,
> Bhavin.
>
> - Original Message -----
> From: "Colin Cooler" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, June 09, 2002 3:55 PM
> Subject: Newbie MySQL installation problems (specific)
>
>
>> Buying Paul DuBois' most excellent book "MySQL" has made me more
> comfortable
>> with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as
> the
>> web database for a redesigneed site at Right Moves For Youth (trying to
> keep
>> "at risk" kids in school).
>>
>> After running his "cleanup instructions" and then downloading and
> installing
>> the mysql package from Marc Liyanage's site, I tried to run the following
>> command (as per instructions):
>> "sudo ./scripts/mysql_install_db;" I then get the following results:
>>
>>> Preparing db table
>>> Preparing host table
>>> Preparing user table
>>> Preparing func table
>>> Preparing tables_priv table
>>> Preparing columns_priv table
>>> Installing all prepared tables
>>> ERROR: 1062 Duplicate entry 'localhost-root' for key 1
>>> ERROR: 1062 Duplicate entry 'localhost-root' for key 1
>>> 020609 0:35:05 ./bin/mysqld: Shutdown Complete
>>
>>
>> When I try to start mysql from the command line, I then get the ubiquitous
>> error message: "ERROR 2002: Can't connect to local MySQL server through
>> socket '/tmp/mysql.sock' (2) "
>>
>> I also discovered a "localhost.err" file in my data directory which yields
>> the following information:
>>
>>> 020609 01:09:50 mysqld started
>>> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
>>> If you do not want to use transactional InnoDB tables, add a line
> skip-innodb
>>> to the [mysqld] section of init parameters in your my.cnf
>>> or my.ini. If you want to use InnoDB tables, add for example,
>>> innodb_data_file_path = ibdata1:30M
>>> But to get good performance you should adjust for your hardware
>>> the InnoDB startup options listed in section 2 at
>>> http://www.innodb.com/ibman.html
>>
>>> 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write
> to
>> file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
>>> 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file:
>> './mysql/host.frm' (errno: 13)
>>> 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of
>> '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
>>> 020609 01:09:52 mysqld ended
>>
>> Finally, when I try the following: "mysqladmin -u root status" I also get
>> the "can't connect through /tmp/myssql.sock" error message.
>>
>>
>> No matter what I try, I can't seem to connect to mysql so that I can even
>> BEGIN to figure out how to correct the 1062 problem! Can anyone tell me
> how
>> to what the "ERROR: 1062" message means and how to resolve this mess?
> I've
>> searched the archives, and this error appears to have occurred
> o
Re: Newbie MySQL installation problems (specific)
Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file & start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: "Colin Cooler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) > Buying Paul DuBois' most excellent book "MySQL" has made me more comfortable > with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the > web database for a redesigneed site at Right Moves For Youth (trying to keep > "at risk" kids in school). > > After running his "cleanup instructions" and then downloading and installing > the mysql package from Marc Liyanage's site, I tried to run the following > command (as per instructions): > "sudo ./scripts/mysql_install_db;" I then get the following results: > > >Preparing db table > >Preparing host table > >Preparing user table > >Preparing func table > >Preparing tables_priv table > >Preparing columns_priv table > >Installing all prepared tables > >ERROR: 1062 Duplicate entry 'localhost-root' for key 1 > >ERROR: 1062 Duplicate entry 'localhost-root' for key 1 > >020609 0:35:05 ./bin/mysqld: Shutdown Complete > > > When I try to start mysql from the command line, I then get the ubiquitous > error message: "ERROR 2002: Can't connect to local MySQL server through > socket '/tmp/mysql.sock' (2) " > > I also discovered a "localhost.err" file in my data directory which yields > the following information: > > >020609 01:09:50 mysqld started > >Cannot initialize InnoDB as 'innodb_data_file_path' is not set. > >If you do not want to use transactional InnoDB tables, add a line skip-innodb > >to the [mysqld] section of init parameters in your my.cnf > >or my.ini. If you want to use InnoDB tables, add for example, > >innodb_data_file_path = ibdata1:30M > >But to get good performance you should adjust for your hardware > >the InnoDB startup options listed in section 2 at > >http://www.innodb.com/ibman.html > > >020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to > file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) > >020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > >020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of > '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) > >020609 01:09:52 mysqld ended > > Finally, when I try the following: "mysqladmin -u root status" I also get > the "can't connect through /tmp/myssql.sock" error message. > > > No matter what I try, I can't seem to connect to mysql so that I can even > BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how > to what the "ERROR: 1062" message means and how to resolve this mess? I've > searched the archives, and this error appears to have occurred occasionally, > but being a newbie to MySQL, I can't understand the solutions to the > problem. Usually this problem has occurred AFTER someone has been able to > successfully connect to mysql. > > Oh Woe is me, > Colin > > > - > 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
Newbie MySQL installation problems (specific)
Buying Paul DuBois' most excellent book "MySQL" has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep "at risk" kids in school). After running his "cleanup instructions" and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): "sudo ./scripts/mysql_install_db;" I then get the following results: >Preparing db table >Preparing host table >Preparing user table >Preparing func table >Preparing tables_priv table >Preparing columns_priv table >Installing all prepared tables >ERROR: 1062 Duplicate entry 'localhost-root' for key 1 >ERROR: 1062 Duplicate entry 'localhost-root' for key 1 >020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: "ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) " I also discovered a "localhost.err" file in my data directory which yields the following information: >020609 01:09:50 mysqld started >Cannot initialize InnoDB as 'innodb_data_file_path' is not set. >If you do not want to use transactional InnoDB tables, add a line skip-innodb >to the [mysqld] section of init parameters in your my.cnf >or my.ini. If you want to use InnoDB tables, add for example, >innodb_data_file_path = ibdata1:30M >But to get good performance you should adjust for your hardware >the InnoDB startup options listed in section 2 at >http://www.innodb.com/ibman.html >020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) >020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) >020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) >020609 01:09:52 mysqld ended Finally, when I try the following: "mysqladmin -u root status" I also get the "can't connect through /tmp/myssql.sock" error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the "ERROR: 1062" message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to successfully connect to mysql. Oh Woe is me, Colin - 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 installation problems on sparc-sun-solaris8
I downloaded the solaris 8 mysql package from ftp://ftp.sunfreeware.com/pub/freeware/sparc/8/mysql-3.22.26a-sol8-sparc-local.gz and installed it, but when i try to run /usr/local/mysql/bin/safe_mysqld, it reports the following error to /usr/local/mysql/var/wakko.err: mysqld started on Thu Apr 12 15:29:39 PDT 2001 ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory mysqld ended on Thu Apr 12 15:29:39 PDT 2001 any idea how to fix this? i tried looking for the libstdc++.so.2.10.0 library, but to no avail. Should i compile mysql from scratch or look more for the library. any ideas/experiences would be greatly appreciated. thanks, ethan [EMAIL PROTECTED]
