MySQL-shared RPM Install
I'm having problems installing the shaired libraries. This RPM came from
the MySQL.com download site.
[root@localhost src]# rpm -i MySQL-shared-4.0.17-0.i386.rpm
warning: MySQL-shared-4.0.17-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL And Shared Storage
--=_D38DA341.B3D2A80A Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I would like to set up a round robin cluster with mysql. The round robin = would be done through the DNS to two different servers. Each of those = servers would have mysql installed and each would reference the same data = directory on our SAN. Are there any problems with doing this? =20
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
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 !
UDF Shared Library
I am trying to create a User Defined Function (UDF) using mySql 4.1.11 (mysql-max-4.1.11 for Solaris 8). I am trying to get the examples to work (udf_example.so) I have successfully compiled it and copied the resulting .so file to /usr/lib. The command 'crle' (like ldconfig on Linux) shows that /usr/lib is in the library path, but when I type in mysql: CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so" I get the error 1126, Can't open shared library 'udfexample.so' I've tries renaming the library 'libudf_example.so', but that didn't work either. I don't know how to check what libraries mysql is looking through. I am just guessing that it uses the library path from 'crle'. Any ideas?
View Replies !
Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool. Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?
View Replies !
Replication Using A Shared Fileserver
I thought of a radical way to do replication of MySQL servers. Let's assume two MySQl servers access a shared mapped storage (/mnt/db) which is a local mount to a fileserver on the network. This fileserver is shared between the MySQL servers; which means any writes to /mnt/db appears immediately on /mnt/db on the other MySQL machine. Two MySQL servers may attempt to modify to the same file if we don't use synchronization. My question is, first, can we do this without making patches to MySQL code, and somehow using some synchronization mechanism accross the two machines running MySQL server each. Or we need to patch MySQL code to support such architecture. Second, is it trivial or impossible to do, how much man-time it requires roughly.
View Replies !
Connections On Shared Server
I frequently get the error message: Warning: mysql_connect(): User user1 has already more than 'max_user_connections' active connections in /home/.sites/60/site23/web/Connections/mysite.php on line 9 It's commercial web hosting on a shared server so I have no control over the server side of things. The php scripting has been written using the GUI in Dreamweaver. Is there anything I can do to resolve this? Should I be using mysql_connect or mysql_pconnect, or is this not the problem? Do I need to include somewhere in my scripts a snippet which disconnects from the server? If so where would I put this? I am not all that familiar with php and mySQL, though I understand parts of it when looking at the code. The database connection is made via a connection.php file produced by Dreamweaver which includes the database details etc. My max connections are only 10. Is this the issue? It only seems to appear when I use php to edit or add to the mySQL database.
View Replies !
Find Shared Values
Say I have a one long Table of people and the foods they like. How do I find all the foods that are like by both of two particular people? ie David peas Kate sausages Kate eggs Bill eggs Kate peas Fred sausages Fred peas and i want to find out what both Fred and Fate like:
View Replies !
How To Find Out Values Shared By Some Members
I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. Code:....
View Replies !
Shared Column Data Transfer
I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1. select * from tbl1, tbl2 where tbl1.column = tbl2.column; Above query gives me the results that need to be updated. What will the update statement look like?
View Replies !
Multiple Database, 1 Shared Table, Is It Possible?
I Used MySQL for a long time dev under PHP 3, 4 and now 5 now i'm facing a problems that i solved in the past with php, but i wonder if MySQL could do it on it's own, that'll help me a lot. Multiple database, 1 shared table, is it possible? i mean, i already done with 5 install of Xoops CMS and modified it that every install is on the same database, with deifferents prefixes (like db1_ db2_ ...) then i mod Xoops for each time it called for it's users or saved open sessions id in the DB it use the same table on all install... so the users seamlessly wonder about in 5 differents xoops install without disconnect and change username. now i face the same problem, i need a multi-install or a single install of a core system that will act as a multi-install sofware, but with the same set of users, sessions and some other things.
View Replies !
Security For Shared Server.xml Passwords
I have an ISP that has the server.xml in a shared environment. The server.xml file is where my password is available for database access under connection pooling. I really would like to use connection pooling. Does anyone know how I can protect my password from being viewed by others using the same server.xml file? I cannot get the administrator to change the protection of the file because others in the shared environment need to be able to view it.
View Replies !
Cannot Open Shared Object File!
i just upgraded from MySQL 4.1 to MySQL 5.1. But when i try to run a program, i'm getting this error: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
Could Not Load MySQL Driver! Compile Php --with-mysql Or Install The Mysql.so Module.
I am trying to install Media Wiki 1.5.2 on Windows XP and I have already installed apache_2.0.55-win32-x86-no_ssl ,mysql-5.0.15-win32 and php-5.1.1-Win32 . When I am trying to install Media Wiki 1.5.2 I receive the following message : Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=mysql.so in your php.ini in C:Program FilesApache GroupApache2htdocsmediawikimediawiki-1.5.2install-utils.inc on line 17 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module.
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 !
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 !
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 !
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 !
Mac (OSX) Can't Not Install MySQL
If i click on the link at THERE ARE DIFFERENT results: Here is result #1 I get a message........... "Internet Explorer does'nt know how to handle the type of file you have selected. You can choose to save this file to your disk or you can configure a helper application." Hre is result #2 I get message............ The file "mysql 2" does not appear to be compressed or encoded. The application "StuffIt Expander.app" might be able to open this file. Would you like to try opening the file using "Stuffit Epander app"? - I try over and over and the above message keeps poping up! Here is result #3" I get message............ "Couln't open the file "mysql 2" because it is not a file that QuickTime understands"
View Replies !
Is There A Right Way To Install MySQL?
I want to create a web application in Dreamweaver with MySQL, PHP and/or Coldfusion. Is there a right way to install these into my Windows XP system, I mean should I install first MySQL followed by PHP and Coldfusion? Also, should I install Apache also? What about IIS? And last, it is better to run Apache with PHP or ColdFusion with PHP.
View Replies !
Install & Use MySQL
I'd like to create a FORUM site for an existing web site and would like to use mySQL for the database. The existing web site currently uses MS Access DB and it's working well. HOwever, for a FORUM site, I believe I will need a more robust DB management system.
View Replies !
Cannot Install MySQL
I've just downloaded the latest version of MySQL form mysql.com (4.0.21) and unzipped it then ran setup.exe. In theory that brings up the install wizard.
View Replies !
How Do You Install Mysql?
I'm very new to this and I've been trying to figure this out for a few weeks now. Theres not many sites that tell you step by step what you need. I have a host that im trying to put phpnuke on. My understanding is that i need to install mysql, phpmyadmin, and then phpnuke. I also understand that you need to configure it. Could someone tell me how to configure the files step by step? It is a linux server.
View Replies !
New To Mysql Install
i installed mysql and its a weird program, "WinMySQLAdmin 1.4". Anyways I got phpMyAdmin also, and I guess I just drop it any of my virtual host folders and it works with the MySQL software. I get some security warnings, Im not too concerned because this is for practice. If i make a new DB in phpMyAdmin it doesn't show up in WinMySQL Admin software. The only one that shows up is the one called "test" that I made in command prompt. This seems kind of confusing, but is there a way I can just make this phpMyAdmin work with WinMySQL Server? I dont know if its a REAL database if its just appearing in phpMyAdmin, this stuff is really confusing to install, I just want to make databases and work it with php, not become an installation expert
View Replies !
Can't Install / Uninstall MySQL
we have a server on which someone blew away the MySQL 4 progs directory before installing MySQL 5. When installing MySQL 5 the installation failed with an error stating that it was unable to create system tables as the MySQL 4 directory did not exist. We are now unable to uninstall MySQL 5: [root@server1 local]# rpm -i MySQL-server-standard-5.0.18-0.rhel3.i386.rpm warning: MySQL-server-standard-5.0.18-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 package MySQL-server-standard-5.0.18-0.rhel3 is already installed [root@server1 local]# rpm -e MySQL-server-standard-5.0.18-0.rhel3.i386.rpm error: package MySQL-server-standard-5.0.18-0.rhel3.i386.rpm is not installed
View Replies !
Mysql 5.0.22 Install On Solaris 10
I'm trying to do an install of mysql on a Sun Ultra 10 machine running Solaris 10 (1/06) which is a completely clean, fresh install. I can get the packaged (with Solaris 10) version of mysql (4.0.something) running easily. I do have version 5.0.15-standard installed and running on another machine. It appears that between 5.0.15 and 5.0.22 someone has made a decision to change the locations that the files are sent to and nobody has updated anything (that I can find) in the documentation. If I'm not mistaken, 5.0.15 gets installed in /usr/local/mysql but 5.0.22 goes into /opt/mysql/mysql I am installing the package from the Solaris binary .pkg format which is what I prefer - I'm not into compiling programs from source. This is also a test platform that has a clean disk so that I can test this before I try and touch anything else.
View Replies !
Install MySQL On Win98
I downloaded MySQL 3.23.57 for Windows as I wish to learn MySQL locally and then use the one I already have installed on my UNIX server. I ran setup and rebooted but the WinMySQLadmin program will not start the Server as it has a MyODBC error "Driver 3.51 Not Found".
View Replies !
MySQL 4.0.15-0 Install From RPM, Change Pwd?
I have installed MySQL 4.0.15-0 from a RPM at the MySQL.com website using the command line syntax: root# cd /tmp/downloads root# rpm -i MySQL-server-4.0.15-0.i386.rpm after I install that it tells me to change the default password using a syntax of mysqladmin -u root password 'new password' so I do: root# cd /usr/bin root# mysqladmin -u root password steve and it tells me: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' what do I do now ?
View Replies !
Failed Install Of DBD::mysql
I have installed MySQL v4 (client, server and development rpm's). I've tried and failed to use the recommended mysqladmin to set a root password after the installation (I have another post open on the MySQL newsgroup about this). I'm attempting an alternative solution and using webmin (www.webmin.com) to create/manage access to my databases. Webmin reports "Warning: The Perl module DBD::mysql is not installed on your system, so Webmin will not be able to reliably access your MySQL database. Click here to install it now." So... I set out to install the Perl module DBD::mysql module - I attempted to perform it using the link provided by webmin (which calls CPAN, something I know little about) and from the command line (using perl -MCPAN -e shell and then doing INSTALL DBD::mysql at the CPAN command line). Both give similar output as to what appears below (which I have grabbed from the webmin output, but the errors are identical). Can someone tell me what I am missing and how to resolve? Code:
View Replies !
Install And Startup Mysql
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:mysqlinmysqld --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 Mysql Problems
I have windowsXP and have downloaded the relevant copy of MySql. I run the setup and mysql is placed on c:mysql.....OK so far. I am trying to follow the manual on mysql website but I am struggling. I run the following command below and the console appears with InnoDB commands c:mysqlinmysqld --console I run the above and it seems to hang the console. After the line with socket and port it just hangs? I cant type on the console and there is no prompt I knew this sql manual looked complicated to do but I dont know what to do from here...I just want mysql to run so I can load databases But I cant start the server.
View Replies !
MySQL Install On XP Machine
I just installed MySQL on a Windows XP machine, and upon using the SHOW DATABASES command, I was suprised to see that the only table that exists is the 'test' table. Isn't there supposed to be a 'mysql' table there also? Did I miss something?
View Replies !
Install MySQL Client
Is there any client tools available for mysql like sql server so that i can install server in one machine and client tool in a client machine that will connect to the mysql sever
View Replies !
MySql Can't Install Error
I installed mysql ver 4.1.7 via windows installer. When I installed I got the following error message: install can't connect to mysql server on 'localhost' (10061) I checked the hosts file and 127.0.0.1 local host is listed. If go to the command prompt I can log in and see the databases. If I try to connect via network I get the following error message Client does not support authentication protocol requested by server; consider upgrading MySQL client
View Replies !
MySQL Win32 Install
I've downloaded MySQL community server, the one without the installer, and I've unzipped it into c:. The last time I tried, I downloaded the one with the installer, and well.. I'm entirely newbie so once I did the installation and configuration, the computer start progressively work strange until I had to install windows xp again from zero. I need to install and configure the MySQL database locally, I mean I don't want it to connect to internet. I'm trying to install a weblog server application in this computer but I don't need the weblog to connect to internet, just work into the computer. I don't know nothing about server configuration, databases and things related. Therefore I would like some help configuring MySQL to work locally so the computer OS wont be in danger.
View Replies !
Install And Manage MySQL
I will have to follow-up my company mySQL server. I want to understand more about mySQL, I would like to know if mySQL server can be installed through internet/web like myphpadmin? Or it must be installed locally?
View Replies !
|
TRACKER
