Create DataBase tabe for a user
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. - 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
Create DataBase tabe for a user
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. - 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
MySQL + php + Red Hat Linux 6.2
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 and Header files for development (i386) (766K) MySQL 3.23.46 Client shared libraries (i386) (234K) So, which file must I download and install into Linux system ? Thank for your help ! Merry Christmas & Happy New Year ! Edward. - 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
Re: start MySQL on RedHat problem
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 (as root) ! Edward. - 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
MySQL 3.23.46
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. - 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
Re: MySQL, Red Hat Linux and php
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 better for me ! Edward. - 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
Re: Problem installing MySQL-3.23.45-1.i386.rpm
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 via the standard .tar > > the MySQL server skrewed up and (i think) corrupted a bunch of my DB files > (thank god i keep backups). > Me still being a novice, i decided to just reinstall the MySQL server, i > went to www.mysql.com > and noticed the had a newer version, so i Dl'd that version, and installed: > > packages in order: > MySQL-client-3.23.45-1.i386.rpm > MySQL-devel-3.23.45-1.i386.rpm > > tried to install: > MySQL-3.23.45-1.i386.rpm > but kept on receiving this error (as stated in previous reply): > > error: failed dependencies: > libmysqlclient.so.10 is needed by php-mysql-4.0.4pl1-9 > > was beat myself up for hours about this error, then went back to mysql.com > and noiced the rpm: > MySQL-shared-3.23.45-1.i386.rpm > > installed this and it worked fine. > > this seemed to fix the problem, the i had to do these: > > 1. restore my databases and set proper ownership/permissions (mysql.mysql) > 2. restart the mysql server > 3. restore the mysql users > 4. reset the DB user: root's password > 5. restore settings from the old php.ini to the new one, this step should be > up further, though > > also tried to install: > php-curl-4.0.6-10.arvin.rh7.1.i686.rpm > (tried to install this then realized it for another version of php. > if anyone knows where i can pick up the 4.0.4 of this i'd appreciate >it.) > > i hope posting this back to the board will help someone Hello, You can try to remove the rpm packages of php and MySQL... Then, install php and MySQL at : ftp://updates.redhat.com/6.2/en/os/i386/ If any problem, please mail to me ! Edward. - 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
Re: many connection errors
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 the > error has happened. > It is prob caused by more of my users having php forums. > What i need to find out is root of the cause > > Mark Hello, I have ever installed Linux Red Hat 7.0 , there is no any problem about apache, php and MySQL... So, what do you want me to help you ? Edward. - 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
Re: MySQL, Red Hat Linux and php
"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 that in > their newest distos, it is extremely difficult to customize your computer. >Escpecially > with adding your own Kernel. I have stayed with 6.2 because for the most part, the > directory structures comply with the source packages most people make available. As > long as you keep current with important packages, there really isn't much difference >in > the newer versions, other than a new GLIBC, but you can add that to a 6.2 distro > easily. > > Hope that helps > > Brian Austin Hello, So, what do you suggest me to do ? Thank for your help ! Edward. - 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
Re: many connection errors
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 > /home/domain/domain42/web/drwho/php/common.php on line 18 > > Warning: MySQL Connection Failed: Host 'localhost' is blocked because of > many connection errors. Unblock with 'mysqladmin flush-hosts' in > /home/domain/domain42/web/drwho/php/common.php on line 18 > Couldn't Connect To Database Server > > This effected all users since they all use 'localhost' > > I ran 'mysqladmin flush-hosts'. Looking at the logs i see quite a few errors > > 011130 6:08:54 Aborted connection 58760 to db: 'modderz_db1' user: > 'modderz' host: `localhost' (Got timeout reading communication packets) > 011130 6:18:20 Aborted connection 56028 to db: 'modderz_db1' user: > 'modderz' host: `localhost' (Got timeout reading communication packets) > 011130 9:06:12 Aborted connection 71509 to db: 'modderz_db1' user: > 'modderz' host: `localhost' (Got timeout reading communication packets) > 011130 9:12:56 Aborted connection 66603 to db: 'modderz_db1' user: > 'modderz' host: `localhost' (Got timeout reading communication packets) > > > I did a search and found the info to clear the error but i am not sure what > causes it. > > Mark Hello, Have you ever tried MySQL 3.23.45, php 4.0.6 and Apache 1.3.20 ? Edward. - 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
Re: Problem installing MySQL-3.23.45-1.i386.rpm
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 --replacefiles MySQL-3.23.45-1.i386.rpm > error: failed dependencies: > libmysqlclient.so.10 is needed by php-mysql-4.0.4pl1-9 > > could you tell me how to get around this problem? Hello, What is your system ? Edward. - 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
Re: MySQL, Red Hat Linux and php
"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 good for work with php 4.0.6 > > and Linux Red Hat 6.2 ? > > Thank for your help ! > > > > Edward. Hello, So, can you tell me which version of MySQL is good for work with Red Hat Linux 6.2 ? Thank for your help ! Edward. - 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
MySQL, Red Hat Linux and php
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://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
Re: Mysql apache php
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. - 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
Question of MySQL
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.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
Problem of MySQL
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 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
Re: Symbolic Links to Data
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 > /var/lib/mysql/music) > > I wish to move the database "music" to /home/martyn/mysql. > > I create the above directory, then go into /var/lib/mysql and do "mv music > /home/martyn/mysql" which moves the "music" database where I want it. I > then do "ln -s /home/martyn/mysql/music music" which creates a sym link to > the new location. > > This all seems to work fine (i.e. as a sym link should) but when I run the > mysql client and type "show databases;" the "music" database is no longer > shown. Is there anything additional to the above that I need to do to get > this to work? > > Many thanks, > > Martyn Hello, No any problem with the installation ( rpm package ) of MySQL ? Edward. - 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
Re: MySql on redhat 6.x and above
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 site. Hello, I'm using MySQL with RH 6.x... Edward. - 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
Re: problem with security and user access
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 fun than eating spam" > > yes i did countless times, i'm working on a local Machine without Admin > rights, so i could not add > mysql as a user nor GroupAdd mysql (as in the Manual) nor were i am able > to > > chown -R root /.../.. > chown -R mysql/../../var > chgrp -R mysql/.../... > Might that be responsible for my problems > (i annihilated the whole server and started anew, > i'm just a student charged with building a Library-Database for an > institute, so that is no real prob,but > to no avail, i still got the same problems) > > Greetz janB > > [EMAIL PROTECTED] > == > a different set of mind > > - > 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 Hello, My System is Linux Red Hat 6.2 I compiled and installed MySQL : ./configure \ --with-charset=big5 --with-extra-charsets=complex make make install So, how can I set the security ( user access ) to protect my Database System ? Thank for your help ! Edward. - 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
Security of MySQL
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, how can I set the security of MySQL ? Thank for your help ! Edward. - 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
