Create DataBase tabe for a user

2002-07-19 Thread EdwardSPL
Hello, My system is Red Hat 6.2, My MySQL is 3.23.46 ( rpm package )... Now, when I run "grant all on poll.* to edward@localhost identified by 'edward';" command... I found there is no "poll" directory at /var/lib/mysql/poll ! So, can you help me ? Thanks, Edward. ---

Create DataBase tabe for a user

2002-07-19 Thread EdwardSPL
Hello, When I run "grant all on poll.* to edward@localhost identified by 'edward';" command... I found there is no "poll" directory at /var/lib/mysql/poll ! So, can you help me ? PS : My system is Linux RH 6.2 Thanks, Edward.

MySQL + php + Red Hat Linux 6.2

2001-12-20 Thread EdwardSPL
Hello, My System is Red Hat 6.2 and need to run with php4 and imp ( www.horde.org/imp )... I found the MySQL packages ( RPM ) at www.mysql.com MySQL 3.23.46 Server (i386) (6M) MySQL 3.23.46 Benchmark/test suites (i386) (689K) MySQL 3.23.46 Client programs (i386) (1.7M) MySQL 3.23.46 Libraries an

Re: start MySQL on RedHat problem

2001-12-03 Thread EdwardSPL
Tri Tran wrote: > > I never run mySQL on this Linux box before and now it keep saying that > > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > > when I try to run mysql or run mysqladmin, now to reset the password ? Hello, run mysqladmin -u root password '' -p (a

MySQL 3.23.46

2001-12-03 Thread EdwardSPL
Hello, I want to know does MySQL 3.23.46 is good for work with Red Hat 6.2 ? My means is the version ( 3.23.46 ) no any bug with RH 6.2 ? Is there a new version 3.23.47 / 48 will be producted ? Thank for your help ! Edward. -

Re: MySQL, Red Hat Linux and php

2001-11-30 Thread EdwardSPL
Jorge del Conde wrote: > > Hi, > > As always, the best version of MySQL to work with is the latest stable > release 3.23.46 :) Hello, MySQL 3.23.46 is good for work with Red Hat 6.2 system ? I need to run apache 1.3.20, php 4.0.6 with my system... So, I want to know which version of MySQL is b

Re: Problem installing MySQL-3.23.45-1.i386.rpm

2001-11-30 Thread EdwardSPL
Brian French wrote: > > running > pentium 80 > 64mb ram > 30 gig HD > Redhat Linux 7.1 > perl 5.06 > Mysql > |_ previously 3.23.39 after this went to 3.23.45 > > php 4.0.4 > |_ w/ ZendOptimizer > > how i got to this problem: > was running php/mysql (versions above) > php was installed

Re: many connection errors

2001-11-30 Thread EdwardSPL
Support wrote: > > Hi > > i have php4.0.6 > Can't see why i should change apache as i don't see that as the problem. > is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade > everytime there is a new release. > The server has been up since april this year and this is first time

Re: MySQL, Red Hat Linux and php

2001-11-30 Thread EdwardSPL
"Brian P. Austin" wrote: > > If you are using the MySQL RPMS for RedHat, They install in the /usr directory. > (Redhat dows things differently) > So it would be > ./configure --with-mysql=/usr for PHP compilation. > > as far as upgrading... I have used RedHat for a long time, and have found th

Re: many connection errors

2001-11-30 Thread EdwardSPL
Support wrote: > > MySQL 3.23.39 > RH6.2 > Apache 1.3.12 > > 2 weeks ago mysql stopped with the following example error.(repeated on > other sites that use mysql on my server) > > Warning: Host 'localhost' is blocked because of many connection errors. > Unblock with 'mysqladmin flush-hosts' in

Re: Problem installing MySQL-3.23.45-1.i386.rpm

2001-11-30 Thread EdwardSPL
Brian French wrote: > > hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm > > already installed > MySQL-client-3.23.45-1.i386.rpm > MySQL-devel-3.23.45-1.i386.rpm > > when i try to install MySQL-3.23.45-1.i386.rpm i get the following: > > [root@localhost rpms]#rpm -U --force --replac

Re: MySQL, Red Hat Linux and php

2001-11-29 Thread EdwardSPL
"Brian P. Austin" wrote: > > The RPMS that are available from the MySQL WebSite are OK to use on 6.2. > I personnaly prefer to use the source or .src RPMS. > > But the RPMS work fine on my 6.2 box. > > [EMAIL PROTECTED] wrote: > > > Hello, > > > > Which version of MySQL ( RPM packages ) is goo

MySQL, Red Hat Linux and php

2001-11-29 Thread EdwardSPL
Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:/

Re: Mysql apache php

2001-11-28 Thread EdwardSPL
Auri Net SAC wrote: > Hi > > please who knows a package that install apache + php + mysql in linux, > i know phptriad but its for windows > Thanks for your answer > rvj Hello, If your system is Linux... You need install Apache , php and MySQL ! Edward. -

Question of MySQL

2001-11-28 Thread EdwardSPL
Hello, If you are using MySQL ( install by rpm packages ) with Red Hat 6.2 , please let me know ! Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Problem of MySQL

2001-11-27 Thread EdwardSPL
Hello, My system is Linux Red Hat 6.2... So, Which version of MySQL ( RPM packages ) is good for work with RH 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: Symbolic Links to Data

2001-11-25 Thread EdwardSPL
Martyn Wendon wrote: > Hello, > > I'm having some trouble in re-locating my MySQL databases to a different > directory. My scenario is: > > Platform: Red Hat Linux 6.2 > MySQL: 3.23.43 > > MySQL data currently stored in /var/lib/mysql > The database name is "music" (so files are therefore in > /

Re: MySql on redhat 6.x and above

2001-11-23 Thread EdwardSPL
aravind gorthy wrote: > Hi, > I have some doubts regarding MySql on Linux > environment. > I'd like to install MySql on linux -redhat 6.x and > above. > Could you please guide me how to proceed. > I did not find a specific document on redhat 6.x and > above in the documentations provided in the s

Re: problem with security and user access

2001-11-21 Thread EdwardSPL
behrens wrote: > Ian Barwick wrote: > > > > > > > Have you flushed the privileges after changing the tables? > > > > FLUSH PRIVILEGES > > > > -- > > Ian Barwick - Developer - [EMAIL PROTECTED] > > akademie.de asp GmbH - http://www.akademie.de > > > > "To query tables in a MySQL database is more f

Security of MySQL

2001-11-21 Thread EdwardSPL
Hello, My System is Linux Red Hat 6.2 and my MySQL is 3.23.41 ( *.tar.gz , sources package )... So, can you help me to set the security of the Database System ? The following compile and installation steps : ./configure \ --with-charset=big5 --with-extra-charsets=complex make make install So,