List:General Discussion« Previous MessageNext Message »
From:dubick Date:March 25 1999 2:24pm
Subject:broken pipe/can't connect/mysql problems...
View as plain text  
>Description:
	I cannot create or access and databases in mysql.  The mysqladmin create
command does not work. Attempts to fix this problem have uncovered other possible
problems, such as broken pipes, failure to connect, and so forth.  I have edited the
configure file (line 18) to reflect the location of mysql.  the executable is residing at
the standard  place (/usr/local/mysql/bin/mysql) and all other pieces follow the standard
binary (non-rpm) installation.

>How-To-Repeat:
cut and paste from attempts to run various utilities:

*****various test/config/access/admin problems ********

[root@cooper mysql]# bin/mysqlaccess cooper nobody test
mysqlaccess Version 2.03, 27 Feb 1997
By RUG-AIV, by Yves Carlier (Yves.Carlier@stripped)
This software comes with ABSOLUTELY NO WARRANTY.
Broken pipe
[root@cooper mysql]# ./configure 

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:
./bin/mysqladmin -u root password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at http://www.tcx.se
Support MySQL by buying support/licenses at http://www.tcx.se/license.htmy.

Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@cooper mysql]# Starting mysqld daemon with databases from /usr/local/mysql-a
mysqld daemon ended

[root@cooper mysql]# ./bin/mysql_fix_privilege_tables 
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.

If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server (2)
Changing name of columns_priv.Type -> Columns_priv.Column_priv
You can ignore any errors from this
ERROR 2002: Can't connect to local MySQL server (2)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)
[root@cooper mysql]# ./bin/mysql_fix_privilege_tables --host cooper
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.

If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server (2)
Changing name of columns_priv.Type -> Columns_priv.Column_priv
You can ignore any errors from this
ERROR 2002: Can't connect to local MySQL server (2)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)
[root@cooper mysql]# ./bin/mysql_fix_privilege_tables --host cooper -u root
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.

If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server (2)
Changing name of columns_priv.Type -> Columns_priv.Column_priv
You can ignore any errors from this
ERROR 2002: Can't connect to local MySQL server (2)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)
[root@cooper mysql]# ./bin/mysql_fix_privilege_tables -hcooper              
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.

If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
ERROR 2002: Can't connect to local MySQL server (2)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)

Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server (2)
Changing name of columns_priv.Type -> Columns_priv.Column_priv
You can ignore any errors from this
ERROR 2002: Can't connect to local MySQL server (2)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server (2)
[root@cooper mysql]# 


ACCESS PROBLEM**************

[root@cooper mysql]# bin/mysqlaccess --h cooper -u root -d test
mysqlaccess Version 2.03, 27 Feb 1997
By RUG-AIV, by Yves Carlier (Yves.Carlier@stripped)
This software comes with ABSOLUTELY NO WARRANTY.
Broken pipe
[root@cooper mysql]# bin/mysqlaccess --h cooper -u root -d mysql
mysqlaccess Version 2.03, 27 Feb 1997
By RUG-AIV, by Yves Carlier (Yves.Carlier@stripped)
This software comes with ABSOLUTELY NO WARRANTY.
Broken pipe


>Fix:
	No clue.  I do know that i must specify the host every time i log into mysql.  i am able
to call up the mysql commmand line/prompt, but when i type show databases, the following
occurs:

[root@cooper mysql]# bin/mysql -h cooper
Can't read dir of '.' (Errcode: 2)
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 101 to server version: 3.22.20a

Type 'help' for help.

mysql> show databases;
ERROR 12: Can't read dir of '.' (Errcode: 2)
mysql> show tables;
ERROR 1046: No Database Selected
mysql> quit
Bye
[root@cooper mysql]#  



>Submitter-Id: dubick@stripped	
>Originator:	dubick@stripped
>Organization:  mit
 
>MySQL support: extended email support 
>Synopsis:	unable to connect/create database	
>Severity:	critical	
>Priority:	high	
>Category:	mysql
>Class:		support
>Release:	mysql-3.22.20a (TCX binary)

>Environment:
	
System: Linux cooper.media.mit.edu 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='gcc'  CFLAGS='-O6 -mpentium -fomit-frame-pointer'  CXX='gcc' 
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors'  LDFLAGS='-static'
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX binary'
--enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared
Perl: This is perl, version 5.004_04 built for i386-linux
Thread
broken pipe/can't connect/mysql problems...dubick25 Mar
  • broken pipe/can't connect/mysql problems...Michael Widenius26 Mar