MySQL Running In Linux With Apache2
I have Fedora Linux running on my box. I have installed Apache2, PHP, MySQL. I used YUM to install everything.
yum install httpd
yum install php
yum install mysql-server mysql
yum instal php-mysql
What I want to know is that how can I start playing around with all this cool programs. I want to learn as much about all these awesome programs. I would like to install some kind of control center for MySQL. I heard MyPHPadmin is good. But how do I install it?
Can I do it through yum? Where can I find a good newbie guide?
thanks in advance :-)
Fedora Project
Information is Power!
I am doing this for the love of MySQL.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Mysql Running Slow On Mandrake Linux 10.0 For AMD 64
I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all queries(updates are especially slow) are running 20/30 or more times slower than on an inferior(32 bit processor, 1.5GB RAM) machine runnning Mysql 3.23.56 on mandrake 9.0. As far as I can tell mysql is configured correctly for the power of the machine. The my.cnf file looks like this: Code:
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
Running 4.1 And 5.0 On Linux
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3 in particular? My goal is to do no harm to my current 4.1 setup. Can the 4.1 and 5.0 rpm's play nice together? Can I use the rcmysql commands for running multiple versions?
Running A Sql Batch Script From The Linux Command
s this possible? I want to write a command script which i want to put into a cron job which will download a db backup from cpanel. then i want to unzip it, and run the sql file, so keeping the database on the mirror machine up to date. So what i have is: #get the database wget -v --http-user user --http-pass pass https://www.site.com/path/to/cpanel/backup #move to backups folder date=`date -I` mv -fv ./mysqldump.gz /home/user/dbbackup/$date.gz now what i also want to do is: mysql -uuser -ppassword u database set foreign_key_checks = 0; . mysqldumpfile.sql set foreign_key_checks =1; exit is it possible to do that last bit from the command-line? as far as i know, a shell script can't run commands to mysql?
PHP + MySQL On Apache2
I just made a server out of one of my old computers. I installed Apache2 and the latest versions of PHP and MySQL. Now, the server is working great, I can run PHP scripts like I want and I can use shell access to connect to the database. I even managed to create a new database. BUT, when I try to use PHP to connect to my database everything doesn't work so good anymore. I tried to install phpMyAdmin but that complained before I even got to the settings. Now I'm trying to install phpBB 2, something I've installed many times before on other servers. When I run the install script I get "The PHP configuration on your server doesn't support the database type that you chose". I've found a few things about this here and there but nothing I've tried so far has worked out.
Local MySQL DB With PHP And Apache2
this is the environment: Windows XP Professional V2002 SP2 Apache Server 2.0.54 PHP 5.0.5 MySQL 4.0.21. All applications are working as such (Apache, PHP and MySQL DB), but when I try to connect to the DB, nothing happens (not even an error). I was reading around a bit and tried some stuff. Eventually I found some things I haven't done): #### went into php.ini and inserted the path of the apache document root path into the doc_root field in addition inserted the extensions dir path to the extension_dir field in php.ini, which was c:phpext scrolled down to almost the bottom of the php.ini file and deleted the 'comment' character to activate the php_mysql.dll extension. ### Now, I did this, but when I restart the Apache Server I get two error messages: PHP Startup: Unable to load dynamic library 'C:phpextphp_mysql.dll' - The specified module could not be found. This does not make sense, because the dll IS in that folder. I even reinstalled PHP and reconfigured the ini-File. Nothing. And it really, really, REALLY am getting annoyed here (yes, I tried forward slashes).
Unable To Access MySQL From Apache2+PHP4
this is the first time I (try) to set up my own webserver. Installing/configuring Apache2 went fairly well with some help, and PHP4 too. But the problem now is that I don't really know how to use MySQL. I mean, I know some easy SQL stuff, but I don't know much about installing such a server program. I've searched the forums, and found this post. Well, I got a page in the htdocs dir which shows a listing of PHP statistics (with the phpinfo() command). I've added a screenshot of the MySQL stats which this page shows, with this post. So then I tried the following step which Mr. Oshikorosu explained, I copied his script and put it in a file. However, I already have a password setup for my root account, so I changed this: $password="mypassword";. Then when I accessed that page, I got this error: Error 1045: Access denied for user 'ODBC'@'localhost' (using password: NO). What did I do wrong and what do I have to do to be able to use the MySQL function with PHP4? I tried reading this doc from the PHP Manual, but I don't really understand it and also, the php.ini file says that my version on windows automatically supports MySQL ?? I'm running all these progs on Windows XP Pro btw.
Mysql5 Setup Php5, Apache2
Trying to setup mysql5 to run with apache 2 and php5 and having very little luck. I've followed instructions from many sites and yet it still isn't being recognised when using the php functions to connect to the db. mysql runs fine on it's own as I've been using it. I've downloaded the *.dlls from mysql and installed them in the correct dir's, uncommented the mysql dll in php.ini and restarted apache.
Installing Mysql5 (winXP, Apache2, Php5)
Using window XP. I install Apache_2.0.55, PHP 5.1.2 installer. After testing, server can run with php codes properly. However, How to install mysql5 and combine with Apache3+php5?? Where should i choose for install path way?? Should i choose C:Apache2 ??? I decide to install mysql-essential-5.0.18-win32.msi and the path way is C:mysql finish installation..... How can i start mysql5??? directly double-click mysql.exe => a "bee" sound heard and the file self -close immediately. I try to click other exe diles and all of them self-close immediately. Code:
Help Please Running Mysql On Os X
I am very new to mysql. I am using the sitepoint book 'Build your own Database Driven Website using PHP and MYSQL. I have installed mysql mysql-5.0.41-osx10.3-powerpc. Under preferences/mysql it indicates that the mysql server is running. When I try to access mysql through the terminal window I get a message - command not found. Or no permissions. I can go to the bin directory and list the contents - they seem to be there. I can't get past page 21/22 Post-installation setup tasks. I am also new to using the terminal window. I suspect I have missed something really basic - any suggestions on how I can get up and running would be much appreciated!
Need Some Help In Getting MySQL Set Up And Running.
I wasn't sure if someone would be able and willing to help me, but I am new to installing MySQL on a Windows 2003 server (actually .. any server), but I am installing it on a Windows 2003 server right now. I also installed a new version of PHP on the same server. Everything looks fine, but when I go to phpinfo.php I don't see anything saying MySQL. (I saw somewhere that if MySQL is installed properly, it should be displayed on the phpinfo.php page.) I am currently trying to set up and run Cerberus Help Desk, but it isn't finding the MySQL database that I installed. So, I would really appreciate it if someone could not just help me via email or postings in here, but actually by using Instant Messenger (AOL, Yahoo! or MSN) to walk me through the set up, testing, etc. so I can get things up and running properly. I was hoping that someone with more experience than I might be willing to help me in this manner.
Could Not Get MySQL Running
I went to MS-DOS to start the MySQL application by typing mysqld into the bin directory of where I installed MySQL but once I did typed the command and pressed enter this is all I got : A moment passed before I am shown the path of bin with no indication of MySQL server started. And also I have installed this as a window service.
Running MySQL 5.0
I've just downloaded and installed 5.0 on my Pc/ win 98se. When I run the program MySQL Command Line Client, it appears to run for a second then disappears. I see the program flash open for a second and then it is gone.Complete newb needs some help.
MySQL 4.1 Running
I've been running mysql 4.1 for sometime and using phpMyAdmin (v2.6.2) to administer the databases. Using php scripts I can also update/insert etc the databases (maintained on my laptop Mac OS X Tiger). Suddenly, I can't get phpMyAdmin to load in the browser. I've also tried other MySQL GUI tools like CocoaMySQL and Navicat....they won't run either. I downloaded and installed phpMyAdmin 2.6.3-pl1 as well but no improvement. Why would mysql run but the admin apps not work?
Running MySQL From A CD-ROM?
I have used PHP and MySQL for a few years now. Just today I can across an application that had a MySQL database running locally off a CD ROM. I did not know this was posible. When the application runs it starts up the MySQL database without the user even knowing they are running it. It is pretty amazing. So I want to do the same thing. Is there any documentation on how to run MySQL locally. I would like to know how to build the database and create tables under these curcumstances.
Running MySQL
I have installed mysql-3.23.54-win and it all seems to have gone OK .... now i want to run it and setup a database. I dont have an icon on the desktop and there is nothing in Start - Programs ..... start it from DOS prompt via C:> C:mysqlinmysql.exe and i get error 2003 cant connect to MySQL server on localhost <10061>
MySQL Is Running, But I Can't Connect
I really need some help with this. MySQL will not start on boot despite everything I've done to make sure that it is set to do so. When I start it as root from a terminal with "/usr/bin/mysqld_safe --skip-grant-tables &" I show several mysqld procs. and one mysqld_safe, but I can't connect: [root@adamsmdk madams]# ps -aux| grep mysql Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html root 3650 0.0 0.1 2276 664 ? S 11:09 0:00 /usr/lib/courier/authlib/authdaemond.mysql start root 3654 0.0 0.1 2316 792 ? S 11:09 0:00 /usr/lib/courier/authlib/authdaemond.mysql start root 3655 0.0 0.1 2276 664 ? S 11:09 0:00...............
Gdb Bus Error When Running App With Mysql 5.0
When linking with mysql 5.0 library, I can't no longer use gdb to debug my app anymore. It cores immediately with a bus error. I've also noticed that the size of the executable is more than doubled compared with one linked with mysql 4.0
Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences?
Running Two MySQL Versions
Actually what I want to do is remove 4.1 because I downloaded 5.0 and installed w/o removing the previous version. I now have port 3307 for 5.0. Is this a problem and how can I change it back to 3306 so e.g. when I use Apache/PHP evrything works?
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app. if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.
Running Mysql From Shell
I need to run this sort of querys from shell: delete from 3dinformatica where preco = " " ; CREATE TABLE tudotest AS SELECT DISTINCT * FROM 3dinformatica; DELETE FROM 3dinformatica; INSERT INTO 3dinformatica (cr_datetime,produto,vendedor,preco,link) SELECT DISTINCT cr_datetime,produto,vendedor,preco,link FROM tudotest; DROP TABLE tudotest; i wanted to put the mysql cmd in a file like mysql.sh and run it from crontab. i have about 100 querys like that i need to run at the same time.
Running Mysql On Old Computers
I´m running mysql on a Pentium 166 Mhz with 16 Mb of RAM. Pretty old, right? I want to know if there is a way to improve performance. I don´t know, something about reducing the number of queries that it will respond or cutting out some features.
Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP.
Running Two MySQL Versions
It seems that my computer is running two different mysql versions. When I'm trying to login to the database it refuse my password and giving me access to the test configuration. This is what i get in the event viewer. Do you already have another mysqld server running on port: 3306 ? Event id 100. The problem occur when I changed my password for the database. I have turned off Mysql in local services but i think that that's the original version. When I start the xampp i think it starts the winmysqladmin version (not sure). How do I reconfigure the hole thing and how can I see what's running on my machine. I actually have another question to. I'm trying to run and open the shell mysqladmin which doesn't work. It's just a flash, which one of them am I supposed to run?? You have several options like mysqladmin, mysql, mysqld, mysqld-nt....etc. I opened the winmyslqadmin which i think wasn't that good.
Running Backup For Mysql
Can anyone suggest a reliable and inexpensive backup service for mysql? I have about 50 tables, of which I've been doing database backups daily on the server, then downloading the backup every couple days or so. The backup files are starting to get relatively large, and I'd like to find a service to backup to off site.
Running MySQL Win32
I'm an absolute beginner and would really like to read something in the manual to solve this problem, but the manual just take care of Unix and Linux users. Because we develop on NT we wanted to install MySQL with Apache and PHP3 on a NT workstation for faster testing beside our Linux station. But I have problem to start the program (mysql.exe). It just gives back an error: Error 2003: can't connect to MySQL server on localhost 10061 Network is running, I can ping localhost. I don't know what to do to get it running.
MYSQL Running Query On Data Through Php...
I am trying to take address info from 5 different fields in mysql, concatenate them into one string of text and have then run through a POST, like you would in a form, and have them spit out on the other end into the database the Lat and Lon of the address... I can do it manually, but I would like to do it automatically... I would like to know if I am going at this right... Psuedo QUERY=SELECT addressNumber, addressStreet, city, state, zip FROM table $addressStr=addressNumber + " " + addressStreet + ", " + city + ", " + state RUN IT THROUGH A POST SOMEHOW??? and call GEOCODER from my manual insert script... $sql=INSERT INTO table SET lat='$lat', lon='$lon'
MySQL Administrator GUI Running Slowly... WHY?
We have created an instance or schema that contains over 14000 tables. It is a lot of tables. When we attempt to browse the tables in the GUI it literally takes 5 minutes or more for it to come back. Granted when using the Microsoft SQL Server Management Studio it is slow but doesn't take that long. After about a minute or so it gives the list and is kind of slow to scroll. Can this be fixed by optimizing the database? Is this just too many tables for mySQL to handle?
Running MySQL Using A Dos Batch File
I am used to use MySQL on Unix, now I have to do some development for MySQL running on Windows machine. The following script works well in Unix but I am unable to run it on Windows. "MY_FLAG" is the one which is causing issue. Due to certain restriction in my framework, I can use the normal batch by supplying the .sql file while opening the mysql connection ( infact i need to run multiple source files) Code:
How To Verify If MySQL Is Running On My Windows XP?
I uninstalled that and reinstalled that. Then it doesn't work anymore... I check the process of the "Windows Task Manager", but I couldn't find the fimilar mysql-nt.exe... Do you have any idea how should I fix this problem? Should I reinstall the whole XP system?
MySQL + SQL Server 2000 Both Running On XP Pro?
I've had mysql on my machine plenty of times with no trouble currently i have SQL Server 2000 Trial running but never both at once. Unfortunately i have to have them both on at the moment. So before i install and mess everything up, Does anyone here have this setup? I basically want to get php/mySQL/MSSQL running with IIS
Error Running MySQL Administrator On RH8
I have downloaded the latest version of mysql administrator 1.0.18. I followed the installation instructions, but when i am unable to run the program. I get an error saying: ./mysql-administrator-bin: relocation error: ./mysql-administrator-bin: undefined symbol: gdk_display_get_type Do you have any clue about what is happening?
Running Mysql Code Within A Php File?
I have been given a some mysql code that I have to run within a website - I am familiar with mysql in terms of insert info and querying a database but I at a loss as to how to make this work. the mysql code works in mysqladmin, but how do I call it into my php code? BTW the mysql code creates a new record in the database ....... Also, I need to tweak the code so it runs in a loop for different variables - in php I would run a FOREACH query, how do I do it in mysql?
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I can not seem to get any of the functions working on it. So I have now dopwnloaded the latest version hoping that this will fix the error. I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but i'm getting the following error message when I install MySQL-server-4.0.1-0.i386.rpm : Code:
Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.
Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?
MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account. Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.
Mysql Running All Queries Double ? How To Avoid ?
Sometimes, when my database server has been slow and building up hundreds of queries, I have the impression that mysql is running 'double' of triple . It's hard to explain, but when I look at mtop (a tool to see what queries are active and what time they take to finish) , I see a lot of queries that seem to hang and that are present more then once. Some of them have unique data in them that can not happen just by refreshing a form. When the peak moment is over, and I check my site, then I sometimes see for example the exact same forum post 3 or 4 times in the same thread. Needless to say, this causes a lot of extra load on my database. I'm not sure what really happens, but it seems like mysql server is just piling up queries wich it can not process fast enough, and those queries seem to come in several times again. I use seperate webservers, but even if I reboot them all, the extra queries still come in as soon as the webserver is back up and php scripts start to work again. The only way to stop it all, is to restart mysql, but that is something that I can not just do very easily. I rely on several heap tables for my site and they need to be refilled with data from normal tables. So restarting mysql is something I only like to do at night, with very few visitors online. I hope I'm explaining my problem well enough. And I hope there is a way for me to check what really is going on, and if there is a way to stop mysql from 'running double' ?
|
TRACKER
