access problem

I have database Zope I run following command and get error myql grant all on Zope.* to [EMAIL PROTECTED]; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'Zope' mysql As a consequece I try to access Zope from a web, it also shows me the error. how can i fix this problem?

php mysql problem

I have redhat 9.0 and Server version: Apache/2.0.40. i have installed rpms php-4.2.2-17.2.i386.rpm php-mysql-4.2.2-17.2.i386.rpm After i create a database called mydb and serveral tables in mysql, I tried to run following testdb.php script

myphp problem

I have redhat 9.0 i have install rpms of apache 2.04, php-4.2.2-17 php-mysql-4.2.2.17 i download the latesest phpmyadmin-2.5.6 but when i try http://coopunit.forestry.uga.edu:8080/phpMyAdmin/ i got error cannot load MySQL extension, please check PHP Configuration. How can i fix this problem?

what is wrong with this perl mysql code?

I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a username i need to check if this username already exsited in mysql database table. if it is already in the table, this program will prompt user to pick another user name. but something

mysql encripted password from perl

I have perl code like my $username = $query-param(username); my $password1 = $query-param(password1); my $sql= INSERT INTO apidbusers ; $sql .= VALUES(?, ?); $sth-execute($username, $password1); In this way, password1 will be in mysql table as plain text. how can i let it

Re: mysql encripted password from perl

sth-execute($username, password($password1)) does not work. On Fri, 28 Feb 2003, Jianping Zhu wrote: I have perl code like my $username = $query-param(username); my $password1 = $query-param(password1); my $sql= INSERT INTO apidbusers ; $sql .= VALUES(?, ?); $sth

where shoud i put sql script

Where should i put sql script in order to use source mysqlscript to create tables in database test? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

is there a better way to store comments in mysql table?

I have a guest book which have three fields. user name email comments I want to mysql to store the information, but commnet maybe very long, is there a better way to handle it instead of set a varchar(2000) or more for a field comment in the table? Thanks

Re: is there a better way to store comments in mysql table?

Thanks for response. what will happen if commnet size is more that 2000? J.P. On Wed, 26 Feb 2003, Paul DuBois wrote: At 21:32 -0500 2/26/03, Jianping Zhu wrote: I have a guest book which have three fields. user name email comments I want to mysql to store the information, but commnet

what is the best way to check if primary key exists?

I need to insert recond to mysql use servlets, insert into mytable values('key', 'f1'); i need to chech if key is already in mytable. what is a good efficient way to do that? Thanks - Before posting, please check:

varchar and java string in sql query ?

? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http

encrypted password

I have mysql in a redhat machine. I need to use mysql do user authentication to a website. I have a table like following. +--+--+ | username | passwd | +--+--+ | jianping | jian1830 | | chichi | jian1830 | +--+--+ I want the passwd field not

apache mod_auth_mysql

I have rehat 7.3 linux server with apache server running, when i try to install mod_auth_mysql, i got followine error msg, [root@mango mysqlsrc]# rpm -i mod_auth_mysql-1.11-1.i386.rpm err: failed dependencies: libmysqlclient.so.10

how to change mysql root password

How to change mysql root password in redhat 7.3 ? Thanks - 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

How to check which version of mysql is installed

I have a redhat 7.1 server, I want to get rid of the installed mysql server. How can check which version is installed and how to get rid of it? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900

My JDBC does not work.

I have spend three days try to get jdbc for mysql work, but failed. I am very frustrated. I will be appreciated if somebody can help me out. I have redhat 7.2 OS, I download the sever and client mysql .rpm files and instaled it, i believe succssfully. i use command like 'mysqladmin version' to

RE: My JDBC does not work.

attempt. Emil Diego Web Coordinator University of Miami School of Business [EMAIL PROTECTED] ph: 305.284.5449 fx: 305.284.3404 -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 11:22 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

RE: problem in telent to mysql server

into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc

RE: problem in telent to mysql server

to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:19 PM To: Jianping Zhu Cc: [EMAIL PROTECTED] Subject: Re: problem in telent to mysql server At 14:58 -0500 3/14/02, Jianping Zhu wrote

where are my.cnf anf mysql log file.

I installed following two files MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm but I can not fild my.cnf and mysql log files. Why? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900

problem in telent to mysql server

I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? Thanks - Before posting, please

Why I can not connect to mysql (using jdbc)

The code is: //Connect to MySql Server try { Class.forName(org.gjt.mm.mysql.Driver).newInstance(); } catch(Exception e){ System.out.println(Can not get class Name); } try { c = DriverManager.getConnection

can not connet to mysql

Any suggetion appreciated. Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check

where should it put jdbc in my linux server

I have two questions about jdbc 1. which files should i down from www.mysql.com(mm.mysql.jdbc-1.2c.tar.gz or mm.mysql-2.0.4-bin.jar?)? 2. Where should i put the driver and do i need to set some env variables? Thanks -

problem of installing mysql

suggestions appreciated. Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http

which JDBC is better

mm.mysql.jdbc-1.2c.tar.gz mm.mysql-2.0.4-bin.jar Which of these two database driver for MySQL is better? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

problem in mysqi

-client-VERSION.i386.rpm ,MySQL-bench-VERSION.i386.rpm inorder to get the missing files. Any suggestions appreciated. Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900