Install On Redhat 9.0
Could someone tell me how to install mysql in my home pc which runs redhat 9.0 as a operating system.
View Complete Forum Thread with Replies
Related Forum Messages:
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?
View Replies !
JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I receive: ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause' But this query DOES work under my linux 5.0.0-alpha! I can modify the SQL Statement to the following and it works fine: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id RIGHT JOIN building b ON a.sortcode=b.sortcode WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
What Shoud Be Version On Redhat 7.3
I have installed as OS (Operating System) Linux Red Hat 7.3. My issue is that I don't know what kind of MySQL should I download to install on it. Would you tell me what version from Community > Downloads > MySQL Community Server > 5.0 ,I must to download ?
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
Installation Problems On RedHat EL4 On Ia64
I'm running RedHat EL4 on an ia64 system. I've been using PostgreSQL for a while but I now have an app that I think requires MySQL so I wanted to try it out. I tried installing MySQL-server-standard-5.0.18-0.rhel4.ia64.rpm and I get an error that it conflicts with mysql-4.1.7-5.RHEL4.1, so apparently I've already got MySQL 4.1.7 on the system. I want use PHP with MySQL, which means I have to configure PHP and tell it where the MySQL headers are. But I don't seem to have headers, at least not that I can find. I tried uninstalling MySQL 4.1.7 first but it says that dovecot and perl depend on it. I tried installing the "headers" rpm for 4.1 but the only one I found was 4.1.18 and rpm says it conflicts with mysql-4.1.7-5.RHEL4.1. So, any suggestions? I don't think I'm currently using MySQL for anything, but I don't want to break perl. I'd like to get 5.0 running. I just don't know enough about Linux and RPMs to be confident that I can uninstall 4.1 and install 5.0 without screwing something up.
View Replies !
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!
View Replies !
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).
View Replies !
Install
I have mysql installed and have two problems/questions: 1. When I go to start up mysql I receive the following: error 2002 (hy000): can't connect to local mysql server through socket 'tmp/mysql.sock' I have been searching the net for help but haven't found the answer. 2. I want to have mysql start on start up - do I have place a command in /etc/rc.local? If so what? 3. Simiarl to #2, but when I want to start mysql, I have to go to the directy /usr/local/mysql/bin and start mysql that way. I know there is a way to just make it so you can type the mysql command anywhere and logged into mysql
View Replies !
How To Install?
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?
View Replies !
Install 3.23 On Mac OS X
The manual gives instructions for 4.x, but I want to use my Mac as a testing environment running the same version as my server, which is running 3.23.53. I'm running OS X 10.3.8 on an eMac, which is still pretty close to the factory install. I'm currently using MySQL with PHP on the server, but I just don't know how to get it running on my Mac. I'm a newbie to Unix, so I don't even know how to get the "shell>" prompt on the Terminal, which is where most instructions begin.
View Replies !
New Install
New install on Windows, MySQL version 4.00.x, i got through a few obstacles, but I'm stuck on this error: "041012 0:16:33 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist" Where do I go from here?
View Replies !
First Install
I'm trying to install mysql on my linux box for the very first time and can't seem to get it going. I downloaded the mysql app to a /downloads folder i created on the / of the linux box. I then right clicked what i'm thinking is the setup icon and clicked install and it appeared to install the files. Yet when I navigate to the /var/lib directory I don't see the mysqql files. I'm thinking I may have messed up by creating and downloading to this directory. Can someone help me out on this or point me to a well documented source?
View Replies !
Mysql RPM Install On FC4
I have just installed MySql 5.0.18 on a fresh installation on RH fedora core 4 using RPMs but the service won't start. Any ideas, can I see a log of why its failing anywhere?
View Replies !
Is Version 5 Ok To Install?
I am currently using MySQL 3.23 for a live web site. I have new queries that need UNION provided in v4.0.0+. It's a simple db with 5 tables and doesn't perform any e-commerce type transactions. All of the 7 tables are of type MyISAM. So I have to upgrade MySQL on the live server. Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the application is simple - is version 5 safe? My guess is that the core of the server engine would be much the same for simpistic queries? What are other people experience and thoughts on this? I understand that safest would be version 4, then 4.1, then 5 - however it would be nice to have 4.1's ability to do subqueries and derived tables.
View Replies !
Version 5 Install
I am currently using MySQL 3.23 for a live web site. I have new queries that need UNION provided in v4.0.0+. It's a simple db with 5 tables and doesn't perform any e-commerce type transactions. All of the 7 tables are of type MyISAM. So I have to upgrade MySQL on the live server. Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the application is simple - is version 5 safe? My guess is that the core of the server engine would be much the same for simpistic queries? What are other people experience and thoughts on this? I understand that safest would be version 4, then 4.1, then 5 - however it would be nice to have 4.1's ability to do subqueries and derived tables.
View Replies !
Install On Windows XP
I cant get mysql to run on my winXP computer. I have downloaded it and installed , unzipped and run setup.exe and placed it in c:mysql. I type the command to start the mysql server c:mysqli mysqld --console It opens the console and then the console shows some inoDB commands and the console hangs. I followed the mysql manual and i cant find the answer there is no command prompt and nothing...how do I run mysql?
View Replies !
Install ByteFX In IDE
How should I correctly install ByteFX in VS.NET IDE? I just used Tools-> Add/Remove Toolbox Items.. and add ByteFX.MySqlClient.dll to Toolbox. What should I do with ByteFX.MySqlClient.Design.dll? I asked because once I read in microsoft.public.dotnet.framework.adonet mail like this: ‘(…)ByteFx.Data.dll, it shows at design time a dialog to create a MySql connection string (…)' And I wondered why I didn't have this in my IDE.
View Replies !
Install New Version
I would like to install the new versin of mysql but currently i have mysql version 3.23 running...I need to have 2 version of mysql running at the moment in win2000 for different app.what is the steps for me to install the new version of mysql without causing error and able to run concurrently.
View Replies !
Install On Xp Home
I'm trying to install mysql on win XP home with service pack 2. I've used the installer numerous times on win server 2003, xp professional and win98, but it doesnt want to work with xp home.Is there any known issues with xp home? I click on setup, my cursor changes for a split second to an hourglass, but thats it!
View Replies !
MySQL Install
I am having a program created for me but it is not working. My programmer claims it is because MySQL is not properly running. He says I should see lights from MySQL in the task bar, but I do not.When I run services.msc it says "mysql" "started"
View Replies !
MySQL/PHP Install
Forgive me if I'm being an idiot, this is my first time installing anything on Linux (RedHat 6.2). I successfully installed MySQL (3.23.32) using the rpms (I created a test db that works fine). Now I'm trying to install PHP (4.0.4pl1), but configure gives me the following error: cannot find [mysql] header files under /usr/bin. I'm using the option --with-mysql=/usr/bin because the rpms installed everything there, instead of /usr/local/mysql, which is where I would have installed it if given an option. Poking around I found the header files in /usr/include/mysql, so I tried to specify the option --mysql-includes=/usr/include/mysql, but configure says that's an invalid option.
View Replies !
Username On Install
The *** thing wont let me in, so secretive are these clever sprites! Installing mysql is simple enough (latest version), apache and php work together happily - but not mysql. My problem seems to be the username, as the basedir (default) and the datadir (my own within My Documents) should be OK in the my.ini file. But nowhere did it ask for a username. When I try to connect it says 'No way, go away root@localhost' and whatever I try in place of 'root' - it still wont play. Where/when can I choose the username to force it, screaming, to let me connect to it (Win XP, mysql-essential-4.1.11)
View Replies !
Linux To Install
I am creating a dedicated DB server running mysql. What is the best linux to install for this?Also the db server will have its own ip is there any other additional security measures that should be taken?
View Replies !
Download And Install OSX
I have downloaded the mysql-standard-5.0.24a-osx10.4 .tar archive from the MACOSX section of the download page and expanded the archive using Stuffit Expander 10.0.2. From what I understand I am supposed to end up with .dmg disc image file from which to install Mysql 5. However the archive expands into a number of folders with no .dmg file.
View Replies !
How To Remove SQL 3.X And Then Install SQL 4.X?
I have downloaded and installed Redhat Linux Fedora 3 which comes with MySql 3.23.58.13 pre-installed. I would like to upgrade this to the latest version of MySql. Having read the documentation section it says that i need to completely remove the old version of MySQL before i attempt to install the new version. Since I am new to linux and MySql does anyone know how i can remove it in full and then get started with an installation of the latest version?
View Replies !
Which Version To Install
I've got a book to teach myself MySql and i need the software. when i go to the website there are so many different versions to download. Which one should i use?
View Replies !
Simple Install
i want to install mysql-max version from the tar file i downloaded. i wish to use it sql node in cluster. so i followed the instructions in chap 15 mysql ref manual. but could not find specific instructions to install sql node. and how to configure the my.cnf .
View Replies !
How To Install MySQL 5.0.37
Please anyone explain step by step to me how to install MySQL 5.0.37 ? I downloded "Windows installer" and "Mysql noinstall 5.0.37".My platform is .NET 2005 with Windows XP professional. Which one is first install? i want to my syatem act as a server and other three systems as client.
View Replies !
Cant Install Mysql
Every time I run the mysql instance config.exe it stops at the 3rd step and it says " can not create windows service for mysql. error 0. I have no idea what this means and why I'm getting this.
View Replies !
Install Connector
I must connect with .NET to a MySQL-DB. But the MySQL-DB is not on my local developer PC but on a server in our Windowsnetwork. Where must I install the ODBC or .NET connector, on the local developer PC or on the DB-server ?
View Replies !
MySQL 5.1 Install
I'm a complete newbie and I've just installed MySQL. The application package defaulted the installation to my main drive, but installed the pieces into Adobe Version CS2 Que/data directories. There are pieces of it strewn all over the place. How can I uninstall it, and where should I direct it to be installed. The install 'package' gave me no options other than my main drive.
View Replies !
Cannot 'USE Mysql' In New 5.0.45 Install On Mac
After a new install on a Mac, I cannot USE the mysql database. Even though I cannot USE it, I can select from it. Sean ==================================== $ mysql --user=root Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 Server version: 5.0.45 MySQL Community Server (GPL) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec) mysql> use mysql ERROR 1049 (42000): Unknown database 'mysql' mysql> select User,Host from mysql.user; +------+-------------+ | User | Host | +------+-------------+ | root | 127.0.0.1 | | root | 174.6.1.4 | | root | localhost | +------+-------------+ 3 rows in set (0.00 sec)
View Replies !
JDBC Install
i have recently installed MySQL 5.0.67 on my Mac OS X 10.5.5. I want to connect my web application to a database. I was hoping that someone might point me in the correct direction to get this sorted.
View Replies !
New Install On W2K Machine
I installed mySQL4 on a W2K machine and I'm able to connect from the c:mysqlin command line, I type mysqlshow and see test as the only database. I was reading the documentation online here and it showed a table mysql. Is that a system table that is required? Did something go wrong in my installation or is this ok?
View Replies !
|