Re: perl/mysql issue...

2005-05-03 Thread Chris Wagner
At 10:52 AM 5/3/05 -0700, [EMAIL PROTECTED] wrote:
>'DBD::mysql::db selectrow_hashref failed: Access denied for user:
>'[EMAIL PROTECTED]' (Using password: NO) at /var/www/html/cgi-bin/DBI/Role.pm
>$ mysql -uroot -p
>mysql> CREATE DATABASE livejournal;
>mysql> GRANT ALL PRIVILEGES ON livejournal.* TO
> > lj@'localhost' IDENTIFIED BY 'ljpass';

Yeah, just add [EMAIL PROTECTED] to ur Grants and it should work.  MySQL see's
that ip and not "localhost" when Perl connects to it.






--
REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=--
"...ne cede males"

0100


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Problem opening/finding default database when running mysqld through'safe_mysqld &' command...

2002-12-14 Thread Chris Wagner
>Description:
  Firstly, I don't believe this is a bug, but I really can't figure it out.
  I've installed MySQL through the Red Hat 8 distribution CDs.  When I 
run safe_mysqld, I have the following message:

  [root@localhost bin]# safe_mysqld &
  [1] 25488
  [root@localhost bin]# Starting mysqld daemon with databases from 
/var/lib/mysql
  021213 01:53:09  mysqld ended

 I check the log file, /var/log/mysqld.log, and it says:
 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

 The log file changes each time I execute safe_mysqld, therefore I know 
this is the log file it is using.  I have run the mysql_install_db 
script and it placed all of the default stuff (including host.frm) in 
/var/lib/mysql/mysql/.  The permissions are all checked for 'User' and I 
am logged in as root.  I've tried setting all the permissions completely 
for everyone and tried copying all the default database files to 
/var/lib/mysql/.

  My my.cnf file contains the following:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


I'm also certain this file is being read, since I had to add 
skip-innodb, which was giving me another warning/error message.

Well, I'm pretty sure this is just something stupid I'm missing, but I 
would really appreciate some help.  I've been looking through the 
manual, reading over the sections about trouble starting up several 
times...  No luck.

>Submitter-Id:   Chris Wagner
>Originator:root
>Organization:
None
>MySQL support:  none
>Synopsis:Unable to run mysqld because it cannot find the default 
database which was installed with mysql_install_db
>Severity:non-critical
>Priority:   low/medium
>Category:mysql
>Class:   support ]
>Release:mysql-3.23.52 (Source distribution)

>Environment:
   
System: Linux localhost.localdomain 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 
2002 i686 i686 i386 GNU/Linux
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/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man 
--infodir=/usr/share/info --enable-shared --enable-threads=posix 
--disable-checking --host=i386-redhat-linux --with-system-zlib 
--enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686 
-D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  CXX='g++'  
CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE 
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'  
LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root   14 Dec  9 19:12 /lib/libc.so.6 
-> libc-2.2.93.so
-rwxr-xr-x2 root root  1235468 Sep  5 19:12 /lib/libc-2.2.93.so
-rw-r--r--1 root root  2233342 Sep  5 18:59 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep  5 18:50 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr 
--bindir=/usr/bin --datadir=/usr/share --libdir=/usr/lib 
--mandir=/usr/share/man --infodir=/usr/share/info --without-readline 
--without-debug --enable-shared --with-extra-charsets=complex 
--with-bench --localstatedir=/var/lib/mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock 
--with-mysqld-user=mysql --with-extra-charsets=all --with-innodb 
--enable-local-infile --enable-large-files=yes --enable-largefile=yes 
--with-berkeley-db --with-thread-safe-client 'CFLAGS=-O2 -march=i386 
-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 
'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE 
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'




Thanks a ton.


-
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