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? Than

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

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= "I

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 ca

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

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 ---

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/

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: http://

varchar and java string in sql query ?

----- it fails. why? how can i use java java string to insert a record? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 ---

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 to

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

RE: My JDBC does not work.

st the error message you are getting, that should give us a > better idea of what is going wrong with the connection attempt. > > > Emil Diego > Web Coordinator > University of Miami School of Business > [EMAIL PROTECTED] > ph: 305.284.5449 > fx: 305.284.3404 > >

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 t

RE: problem in telent to mysql server

. > > > > >You need to make sure the user you are trying 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 > &g

RE: problem in telent to mysql server

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: [EMAIL PROTECTED] > Subject: problem in telent to mysql ser

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 chec

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

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 ("jdbc:mysql://localhost/dbname?u

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 - Bef

can not connet to mysql

uot;. What is the potential reason for this. my os is redhat 7.2 Any suggetion appreciated. Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 --

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 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

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