Problem Installing MySQL Max Rpm On RedHat 9
SELECT *
FROM Distance, LorryDetails
WHERE cavan = (Select min (cavan) From Distance where cavan>0);
here is the results i am getting
source ,Cavan, Athlone, Cork, Galway ,LorryID, LorryReg, Position
Athlone 90 0 180 80 3 02-CN-8001 Cork
Athlone 90 0 180 80 7 00-CN-1000 Cavan
Athlone 90 0 180 80 10 02-G-8001 Galway
What i want to try and do is compare the Values with the Column names and get the shortest path. for example when you compare the position cort with the column cork it is 180, cavan is 90, and galway is 80. Galway is the nearest to athlone so i want to narrow down the results to just give me back the row where the position is equal to Galway.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Installing Mysql-administrator On Redhat
I am unable to install mysql-administrator on Redhat AS 4. #rpm -i mysql-administrator-1.1.6-1.i386.rpm erreur: Dépendances requises: libstdc++.so.6(GLIBCXX_3.4.4) est nécessaire pour mysql-administrator-1.1.6-1.i386 But I already have the library: #ls -l /usr/lib/libstdc++.so.6 lrwxrwxrwx 1 root root 18 nov 16 17:27 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.3 Anybody have had such installation problem?
Mysql On SMP CPU Under RedHat
I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ?
Mysql For Redhat 9
im planning to have a mysql server in redhat 9. my question is from the list on the download page of mysql, what should i download? there seem to be so many mysql for linux and i cant find the one for redhat 9.
Mysql On SMP CPU Under RedHat
I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ?
RedHat 8 And MySQL
I recently ran across an interesting problem, and I'm curious as to whether any of you out there have had the same problem. A friend of mine was trying to get his MySQL server running on RedHat, and was having a difficult time. He could not connect from his windows workstation. After a short look at his user table, I could see it was set up to only allow local connections (an obvious default security measure). This is where it gets wierd. From a SSH session, I created a super user with full rights to all databases on all hosts (allowed login from any host). But my friend still couldn't connect from his workstation. I finally realized that the mysql daemon is appending '@localhost' on the supplied username no matter what the user supplies. Thus, a non-local connection fails. Perhaps I'm missing something here...I am obviously not a MySQL expert. But I was able to get my MySQL running very quickly on my Mandrake 9 box. It seems RedHat has made some changes to its distribution of MySQL. I'm not sure what to do next.
MySQL Redhat
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box connects almost immediately. The fast box has standard install of 7.3 with tomcat added. The 9.0 box is straight RH9.0 standard install. I can't find anything in common between the slow boxes, but not on the fast one.
RedHat 9.0 MySQL, PHP CREATE
I have a RedHat 9.0 web server setup for intranet use. When the webmaster tries to use his CREATE DATABASE and CREATE TABLE scripts it tells him that he doesn't have the permission to do it. I've given all the necessary permissions to do it, I think. Any suggestions?
MySQL On Redhat Linux
To make a long story short, let me say I had MySQL working on Windows 98 and everything was fine. Well, I took the big leap and removed all traces of Windows and Microsoft from the computer. (hooray!) Once I had Linux running OK, I downloaded and installed MySQL using an RPM package. I guess the server is running (it says it is every time the computer starts and it stops successfully every time the computer shuts down) however, I cannot figure out how to get the MySQL prompt. I've searched the entire hard drive for MySQL, mysql, MySQL*, mysql* and probably some others, too. The only thing I found was a shell script called mysql that starts or stops the server if I am logged in to Linux as root. I cannot figure out how to start the interactive program that allows me to make select statements, inserts, updates, etc. I'm wondering about some things: Did I download and install the wrong thing? Am I just not looking for the correct thing? Did I install it incorrectly?
MySQL As Part Of RedHat 9 Install
When I did my RedHat9 install, I choose Workstation and customized the packages I wanted install. As a part of that customization, I chose mySQL DB; however, I can't seem to find any RedHat documentation that says how to get to these installed packages. I would like to just start using them, but not sure where to start. Any hints to get up and going quickly?
Activating MySQL In RedHat Linux 9
After being absent for a while now I'm back with this question: Does anyone know of any guide on how to start mysql on Linux? Actually I was writing a long complain that mysql doesn't run on linux! But during the writing I could sort of fix it! Now it works, but only the mysql & test databases are not active coz their directory isn't created. I think I can do something for it myself! I just wanted to know if any of you went through the same experience: running mysql that is already installed with your Linux package, not grabbing a new mysql and deleting the old one and installing the new one!
MySQL Redhat Slow Responding To Connections
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box connects almost immediately. The fast box has standard install of 7.3 with tomcat added. The 9.0 box is straight RH9.0 standard install. I can't find anything in common between the slow boxes, but not on the fast one.
Queue Size Affect MySQL On RedHat
i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ?
Java In Linux (Redhat 9) To Access MySQL
Using a Java program, I can connect to the test database in MySQL. The test database is installed using a MySQL utility, and it can be accessed by any user without supplying a password. The relevant lines in my Java (Java version 1.4.1) code are: Connection con = null; String url = "jdbc:mysql:///test"; // <== no user or password specified con = DriverManager.getConnection(url); However, when I try to connect to the accounting database (built as one follows the Larry Ullman's "MySQL" book), the program fails. I need to supply a user and a password. The relevant lines are now: Connection con = null; String url = "jdbc:mysql:///accounting?user=root&password=pswd"; // <== con = DriverManager.getConnection(url); I cannot get a connection. The error message is: "Invalid authorization specification: Access denied for user: 'root@thorvald' (Using password: YES)" (thorvald is my machine name.) I have tried all sorts of variations on the url, trying to access the accounting database, with no success. I can use the same user/password of root/pswd within the mysql monitor to access anything I want. Any ideas? Again, I am using Linux (Redhat 9) , Java 1.4.1, MySQL 4.0.13, and the MySQL ConnectorJ 3.0.8 (for Java access to MySQL).
Where To Get My SQL For Redhat 9
where can I get a free copy of My SQL. I'm running Redhat 9.0 on my laptop. I looked at www.mysql.com but was a bit confused as to which package I need to download.
Thread_stack On Redhat 8.0
I saw this section in mysql manual. "If you are using Red Hat 8.0 or a new glibc 2.2.x library, you should start mysqld with the option --thread-stack=192K. (Use -O thread_stack=192K before MySQL 4.) If you don’t do this, mysqld will die in gethostbyaddr() because the new glibc library requires a stack size greater than 128K for this call. This stack size is now the default on MySQL 4.0.10 and above." I am using red hat 8.0. Mysql is started automatically when my machine is started. How should I set this variable. Can I add this to my.cnf file and restart mysql. If so how should(format) I add it to the my.cnf file.
Replication Error On RedHat AS 4 ( 5.0.33)
I download the newer MySQL version 5.0.33. And i compile it for multi-threads support on my 64 bit Redhat AS 4 running on DELL 2950. Everything is fine while installation time. But error occues when another slave MySQL contact this new MySQL version master. After trying, I found out some kind of error "ONLY" happen on 64 bit RedHat AS4 and running with mult-threads MySQL. I wound not wanna downgrade my 64 RH4 AS to 32. Although "Non-Multi-thread" MySQL can well run on my 64 bit RH4 AS, multi-threads MySQL still my prefer if it can work out.
Installing MySQL
I have always just had MySQL on servers I have dealt with, so I've logged into the web host control panel and have been able to add users and databases from there, either on the hosts control panel or by PHPMyAdmin. On the particular server I am working with, the server is housed on the premises. So they don't really have a control panel all they have given me are the details for InstaGate EX... Any ideas how I can use this to: a) See if MySQL is on the system b) Add databases to it
Help Installing Mysql
Ok, I'm new to this. My host has Mysql and Php already installed. I'm trying to install and configure the Mysql client in my computer to connect and work with the server. I'm using 4.1.21 as is the one that my host is using. What I do is to install the whole Mysql server in my computer and go through the configuration. Everything is ok, but when I open Mysql Command Line Client it prompts me for the password, I enter it and it introduces itself and leaves me with the Mysql command prompt: msql> I want to connect to my Mysql server and be able to enter the hostname and username of my server. Do I have to install the whole Mysql server in my computer or only the client program? How can I connect to my server? What do I have to do? Thanx for the help
Help Please: Installing MySQL Etc.
I'm trying to install MySQL and PHP onto my machine (A Mac with OS X 10.4). I think I've done it but I'm not sure. And I haven't been able to setup a root password. I'm working through the "Database Driven Websites" book. I've done eveything but then I get stuck on this next bit which I think is to set a root password. It says to type in "mysql -u root mysql" into my terminal but when I do it just says "-bash: mysql: command not found". I don't know if its to do with not being in the bin directory? But I don't know how to do this. I'm very new to this all.
Help Installing Mysql
I am following the tutorial that walks you throught the steps of how to install mysql and php. I have installed both and I am now at the step of : To set a root password for MySQL, open a command prompt (or Terminal window) and type the following command in the bin directory of your MySQL installation: mysql -u root mysql Once I enter this into the terminal window, it says that there is no such command. I am running OSX 10.4.7 I have made sure that mysql server is running. Can you tell me what my problem is?
Installing MySQL On Mac OS X
I have just purchased the sitepoint book, "Build your own database driven website using php and mysql". I'm obviously new to this and I went to the start of the Mac OS X installing mysql. I have downloaded MySQL and installed it. It then tells me to open up the terminal window and type in the command: shell%sudo /usr/local/mysql/bin/mysqld_safe It then tells me to make a file my.cnf and put it in the file: /usr/local/mysql/data/ When I do a search for this folder I get the result "The folder cannot be found". I have tried going back to the terminal and entering the above code again but it says "A mysql process already exists". This is how the terminal displays when I have typed it all in: Welcome to Darwin! Darrens-Computer:~ Darren$ sudo /usr/local/mysql/bin/mysqld_safe Password: A mysqld process already exists
Installing MySQL 5.0.27 On OS X 10.4.8
I'm on page number 29 in "Build Your Own Ruby on Rails Web Application" where Patrick is instructing us on how to install mySQL. I've downloaded the current stable release of mySQL, run the mysql-standard-5.0.27-osx10.4-powerpc.pkg and was told that the installation was successful. Here is my concern: I remember many months ago when I was fooling around with PHP and I recall installing multiple versions of PHP and mySQL on my machine. I remember specifically using Marc Liyanage's packages available on www.entropy.ch as well as MAMP. Now, when I execute the following commands as per Patrick's instructions, I receive errors. From the book: Quote: Excellent. Next, we need to start the server—we’ll do this manually for now. Open a Terminal window and enter the following command: $ sudo /usr/local/bin/mysqld_safe5 This is returned: Password: sudo: /usr/local/bin/mysqld_safe5: command not found mason:~ Mason$ Included in my mysql-standard-5.0.27-osx10.4-powerpc.dmg file is a ReadMe.txt, which provides a different command for connecting to the mySQL server. That is: $ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start Which after entering that, I receive: Starting MySQL database server And yay, the server appears to have been started! Once MySQL is running, you can tell it to run in the background by hitting Ctrl- Z, then entering this command: $ bg When I press Control-Z and enter 'bg', the message returned to me is: -bash: bg: current: no such job Hmm. Does that mean mySQL really isn't running? Also, what does pressing Control-Z do? Anything special? How do I know that whatever it's supposed to do is actually being done? Should something indicate that it's been pressed? Not knowing what to do, I proceed with his further instructions to: Quote: ...close the Terminal window; MySQL will continue to run as a server on your system. Now, all that’s left to do is confirm that the MySQL server is indeed running as expected. In your Terminal window, type the following: $ ps -ax | grep mysql This command should return a few processes that relate to MySQL. Running that command returns this: 4903 p1- S 0:00.04 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/ 4922 p1- S 0:05.15 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysq 7260 p1 R+ 0:00.00 grep mysql Since I'm new to all of this, I can't tell if that's good or bad or if that means mySQL is actually running or it isn't. It does at least appear to show the processes that are running, like he said. Does anyone know if mySQL is actually running though? He goes on to say: Quote: If it does, you can try to connect to your database with the following command: $ mysql5 This should present you with a mysql> prompt I figure, since it does return some processes, like he said it would, it's ok to try that command out. But, oh noes! This is what happens when I do: -bash: mysql5: command not found So, just out of curiosity, I decide to look in /usr/local/bin/ where apparently this thing belongs, but it isn't there! So now I'm at an impasse. I have to wonder, could my previous installations of mySQL be conflicting somehow with my recent one? Why isn't mysql5 in /usr/local/bin/ and why am I not being presented with a mysql prompt when I enter mysql5 into the command line? I'm not sure if I should proceed in the book without first working this out as I question whether or not leaving it unresolved could create more problems and confusion for me down the line.
Installing MySql On AIX Box
I am running AIX 5.1 on an RS6000 for a company wide custom application and database. I need to insall apache and mysql for an intranet on the same box. Any advice before I start? Anything I should be cautious about?
Installing MySQL 4 Or 5
I've got a G4 that runs OS X 10.2.8 and Apache 1.3 I've been trying to install MySQL for a couple days now. I run the installer and it says Installation successful then I install the pref pane, restart the G4 but when I select the MySQL preferences and try to start the server nothing happens. I've tried shutting down any other MySQLs with the Terminal but that comes back with "command not found" I can't find any new MySQL folders either. Any suggestions?
Installing MySQL V4.0.14b
I have just downloaded MySQLv4.0.14b for windows and 21% through the installation, it displays the following error: An error occurred during the move dataq process: -132 Component: File Group: File: The MD5 hash matches the one on your website and I have spent another 5 hours or so downloading it again from your main site instead of a mirror site, but it stills does the same thing. I'm installing it into the the same folder as the previous version (3.23.49).
Installing MySql 5.0
I am new to the world of SQL and would like some help regarding the start at the DOS prompt I have done a basic install but when I type mysql at the DOS prompt I get a "You do not have permission error ..., cannot logon as local host" The SQL server is on the same machine as the installation and I would simply like an anonymous log in.
Installing MySQL V4.0.14b
I have just downloaded MySQLv4.0.14b for windows and 21% through the installation, it displays the following error: An error occurred during the move dataq process: -132 Component: File Group: File: The MD5 hash matches the one on your website and I have spent another 5 hours or so downloading it again from your main site instead of a mirror site, but it stills does the same thing. I'm installing it into the the same folder as the previous version (3.23.49).
Installing MySQL
I am very new to DB installations. But either way I am in charge of setting up MYSQL on our server. Here is what I know. I downloaded MySQL-server-community -5.0.51a-0.rhel3.ia64.rpm i used SSH to put the file on my root now I am using PUTTY to load. but I am completely lost from here. Is there any set directions to install?
Installing MySQL
I am going to start work on a project using PHP/MySQL, and I was wondering if anyone could point me in the right direction on installing MySQL. I know where the website is and all, but I would appreciate if someone would just run through the steps for me.
Installing MYSQL 5.0
I have downloaded MYSQL 5.0 and unzipped it. but i need to know after unzipping which file i need to run to install it on my machine.?
Installing MySQL
I have always just had MySQL on servers I have dealt with, so I've logged into the web host control panel and have been able to add users and databases from there, either on the hosts control panel or by PHPMyAdmin. On the particular server I am working with, the server is housed on the premises. So they don't really have a control panel all they have given me are the details for InstaGate EX... Any ideas how I can use this to: a) See if MySQL is on the system b) Add databases to it
Installing Mysql
I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine.why I may be getting this error.
After Installing MySQL
I finished installing mysql, windows 4.1 essentials, on my machine. I have a fully functional Apache client with PHP, CGI, ASP, etc. ready to go on it. I want to know if there is anything else I need to do, because I'm _new_ at this... What should I put in httpd.conf to get mysql working? Do I need any other programs?
Installing MySQL 5
the steps to installing MySQL 5 on Red Hat Linux 9? When I follow the steps as outlined in the manual or Red Hat text I get an error that Perl DBI must be installed. After attempting to download the Perl DBI; that failed because the server was not availabe. Eventually I was able to download some Perl stuff, but not the DBI. Here is the problem at its root. Where is the information to handle all of the error messages? Where is the source of knowledge to work around these problems?
Installing Mysql On Rh9
im having a nightmare tryng to get mysql to work on rh9. ive tried v4.1 and that didnt work so ive gone to v3.23.49-1 i386. Anyway ive looked around and downloaded a tutorial and done exactly what they have done in the tutorial, but i get an error when i run isql it says Quote: Could not SQLConnect Ive set the directories of the driver & setup file in the odbcinst.ini as he did in the tutorial
Installing MYSql 4.0.12
I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message "030821 <time> MySqld ended". Does anyone know what the problem is ...?
Installing MySQL
I have always just had MySQL on servers I have dealt with, so I've logged into the web host control panel and have been able to add users and databases from there, either on the hosts control panel or by PHPMyAdmin. On the particular server I am working with, the server is housed on the premises. So they don't really have a control panel all they have given me are the details for InstaGate EX... Any ideas how I can use this to: a) See if MySQL is on the system b) Add databases to it
Installing MySQL
I want to install MySql on my computer ,so that I can use it for studying.I want to create tables and run queries from my computer. CurrentlyI have installed mySql and all its components,but I dont know how to customise it to my needs.Can any one help?Or is there any other sql interpreter so that I can use it to build tables and queries for educational purpose.
Installing MySQL
I am just installing mySQL on my laptop. I am just setting the root password. I have already set my password to twinsister: C:mysqlin>mysqladmin -u root passsword twinsister This worked fine. Now I am trying to set the hostname, and I have read in a thread on the net, that you should always set this to localhost, so I have typed this: C:mysqlin>mysqladmin -u root -h localhost password twinsister However, this is the error message I get: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' This is probably very simple to solve, but I just can't think what I am doing wrong.
Installing MySQL
This question will most likely seem unintelligent to you, but here's the basics: I'm doing web design for an organization, I want a mysql database on their server, I have access to this server via ftp, I know the server is Apache... How on earth do I install mysql on this server so I can start designing a database?? I've tried desperately to find a simple solution, but every resource I find is too complex... can anyone explain in simple terms, or perhaps point to a very beginner tutorial on how to get started? Can I even do this myself, or do the people who run the server have to install one for me? I'd much rather do it myself
Installing MySQL On Mac OS X....
Just in case anyone has the same problem. After a few hours, I found the solution for installing MySQL on Mac OS X. As well as a ton of other people, I was getting the error... Can't connect to local MySQL server through socket '/tmp/mysql.sock' Its a problem with permissions. Try this from the terminal, it worked for me... sudo chmod 1777 /tmp and sudo chown -R mysql:mysql /usr/local/mysql/data
Installing MySQL Twice
I posted a message yesterday asking how I could install a database on a separate volume than the default. Here's the thread. It explains why I need to do this: http://www.tek-tips.com/viewthread.cfm?qid=1403489&page=1 Another possible solution to my problem would be to install a second instance of MySQL on the new partition. But I would need to run both instances at the same time on the same OS. Is this even possible? Is there a better way to accomplish this task than what I have proposed in these two threads? “If you are irritated by every rub, how will you be polished?†~ Mevlana Rumi Do you live in Michigan? Join us in the Tek-Tips in Michigan forum.
Installing MySQL 5
I installed MySQL 5 (free version) and at the end, it could'nt start the service, and I got the message: Cannot create Windows service for MySQL. Error: 0
Mysql Installing
now i need to download mysql.can anybody tell me which version of mysql is supported for my platform?also mysql server and client i knew.apart from that, what are the mirrors i need to download? also tell me how to install it and where to install ( means the location . is it in /usr/local or something else).actually am going to work with perl and mysql.hence ,i need this mysql to be installed in the system.
Installing Mysql
i typed into the command line "binmysqld --console"...my firewall alerted me that it was trying to access a DNS...i clicked 'block this action', and then the command line shot me an error: can't start server: Bind on TCP/IP port: No error 050306 [error] Do you already have another mysqld server running on port3306? 050306 [error] Aborting 050306 [note] binmysqld: Shutdown complete and that's where i am. now when i run it again, there is no prompt and it just gives me the error.
Installing Mysql
I need help installing a classified database on my server please!! I have most of it done, db created, I am just missing something somewhere.I am at ncentity at gmail.com I can afford to pay someone 15 dollars via paypal for a few minutes of their time.
|
TRACKER
