List:General Discussion« Previous MessageNext Message »
From:Steve Pennington Date:May 26 1999 11:07pm
Subject:RE: Access denied on fresh install
View as plain text  

Here is a suggestion from a newbie.

Did you try the "-u root" (minus the quotes) switch . I think there is
usually a root account with no password by default.

Steve Pennington (CTO)
NetWORLD Connections, Inc.
------------------------------------
Get Your Free E-Mail And Homepage at
http://home.networld.com
------------------------------------

> -----Original Message-----
> From: web2day [mailto:mailbox@stripped]
> Sent: Wednesday, May 26, 1999 3:46 PM
> To: mysql@stripped
> Subject: Access denied on fresh install
>
>
> >Description:
> I installed MySQL under an user-account. I set TMPDIR, MYSQL_UNIX_PORT
> and MYSQL_TCP_PORT to the right values and I can start safe_mysqld.
>
> But when I want to use the database, I'm not allowed:
>
> bash-2.02$ bin/mysqladmin version
> bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'web2day@localhost' (Using password: NO)'
>
> With telnet, I can make a connection, but I'm simply refused:
>
> bash-2.02$ telnet localhost $MYSQL_TCP_PORT
> Trying 127.0.0.1...
> Connected to localhost.xs4all.nl.
> Escape character is '^]'.
> LHost 'localhost.xs4all.nl' is not allowed to connect to this
> MySQL serverConnec
> tion closed by foreign host.
>
> Ive read chapter 4 and 17 of the manual, searched the mailing-list,
> tried some switches, but all without result.
>
> Can you please help me?
>
> Please reply to e.j.martin@stripped. Thanks.
>
> I installed MySQL from mysql-3.22.21-pc-bsdi3.1-i386.tar.gz.
>
> The environment var's are:
> TMPDIR=/usr/local/WWW/www.web2day.nl/database/mysql-3.22.21-pc-bsd
> i3.1-i386/tmp
> MYSQL_UNIX_PORT=/usr/local/WWW/www.web2day.nl/database/mysql-3.22.
> 21-pc-bsdi3.1-
> i386/tmp/mysqld.sock
> MYSQL_TCP_PORT=40319
>
> Process info:
> 19455  p7  IW     0:00.07 /bin/sh bin/safe_mysqld --skip-locking
> (safe_mysqld)
> 19482  p7  S      0:01.20
> /usr/local/WWW2/www.web2day.nl/database/mysql-3.22.21-
> pc-bsdi3.1-i386/bin/mysqld
> --basedir=/usr/local/WWW2/www.web2day.nl/database/mys
> ql-3.22.21-pc-bsdi3.1-i386
> --datadir=/usr/local/WWW2/www.web2day.nl/database/mys
> ql-3.22.21-pc-bsdi3.1-i386/data --skip-locking
>
> (Here I'm trying the --skip-locking switch).
>
> >How-To-Repeat:
> >Fix:
>
> >Submitter-Id:	<Edwin Martin>
> >Originator:
> >Organization:
>   E-mail: E.J.Martin@stripped
> >
> >MySQL support: [ none ]
> >Synopsis:	<Access denied on fresh install>
> >Severity:
> >Priority:
> >Category:	mysql
> >Class:
> >Release:	mysql-3.22.21 (TCX binary)
>
> >Environment:
> System: BSD/OS lyrix.xs4all.nl 3.1 BSDI BSD/OS 3.1 Kernel #4: Tue
> Jun 23 17:51:35 CEST 1998
> oliver@stripped:/usr/src/sys/compile/XS4ALL-GENERIC  i386
>
>
> Some paths:  /usr/bin/perl /usr/bin/make /usr/contrib/bin/gmake
> /usr/bin/gcc /usr/bin/cc
> GCC: gcc version 2.7.2.1
> Compilation info: CC='gcc'  CFLAGS='-O6 -mpentium
> -fomit-frame-pointer'  CXX='gcc'  CXXFLAGS='-O6 -mpentium
> -fomit-frame-pointer -felide-constructors -fno-exceptions
> -fno-rtti--fast-benchmark'  LDFLAGS=''
> Configure command: ./configure  --prefix=/usr/local/mysql
> '--with-comment=TCX binary' --with-low-memory --disable-shared
> Perl: This is perl, version 5.004_04 built for i386-bsdos
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3996@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>

Thread
Access denied on fresh installweb2day27 May
RE: Access denied on fresh installSteve Pennington27 May