Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.
I have seen some benchmark details on internet. But still they are not
having concrete facts to support LAMP as a better alternative to WAMP.
Allmost all the search done on google melts down to IIS vs Apache, My
main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly
for PHP/MySQL.
View Complete Forum Thread with Replies
Related Forum Messages:
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error. [MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server Is it likely that the windows-linux combination is causing a problem here?
View Replies !
Connecting To Server At Home From ISPs Webserver
The error I get is "mysql_connect(): Can't connect to MySQL server on 'vince.homeaddress.net' (13)" I have added the IP address of the ISP's server, The Static WAN IP address of my server, to the list of allowed hosts for the user on my server at home. And none of this changes that error. I do have a firewall and have opened port 3306.
View Replies !
Suddenly Mysql Won't Start (LAMP Server)
I use a LAMP-server running on Debian Etch as a virtual host on VMWare. I use mysql for a web gallery, but a couple a days ago it seems to stop working, so I tried to restart mysql and webserver, but mysql then fail to start. The syslog have the following info about it: Jul 22 13:11:12 webserver mysqld_safe[3587]: started Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: Can't read dir of '/tmp/' (Errcode: 13) Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [ERROR] Aborting Jul 22 13:11:12 webserver mysqld[3590]: Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [Note] /usr/sbin/mysqld: Shutdown complete Jul 22 13:11:12 webserver mysqld[3590]: Jul 22 13:11:12 webserver mysqld_safe[3592]: ended Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: error: 'Can't connect to local MySQL..
View Replies !
Phpadmin Wamp Server
All I want to do is run a select query of all the records in my table where the arcade game name equals a specific name. I am using the sql creator to do this, SELECT * FROM `bb1_arcade` WHERE `games` = `asteriods`; But the stupid thing keeps erroring saying that asteriods is not a column. Of course its not a column! Its a value! What I want to do in the end is add a value to another field within this table based on the results of the select statement but its just never working.
View Replies !
WAMP Server Solution
I have been working as a LAMP Solution Developer where my technical specifications for the LAMP solutions are: Database backend server is MY SQL running in HP-UX (Hewlett Packard UniX) where I database composed of 9GB. My web server is running on WAMP’s version of Apache HTTP Web Server and my application server is running on WAMP’s PHP version and the platform running on the Web Server is Windows XP on the staging or testing environment. References I use is the wampserver.org The problem is when the client processes some reports from the Database by the PHP Web Page and generates reports through the Php, after 1 hour of validating it expires. Is there a script or an accelerator where I can use to increase the speed of the Php Page without having a page expire or the mysql table itself must be reduced so it can be easily accessed by a Php?
View Replies !
Error 1064 Console On WAMP Server
I am working through an SQL book which gives this example to create authorization for access to a database CREATE SCHEMA AUTHORIZATION JOE CREATE VIEW NEW_CARS AS SELECT * FROM CARS WHERE YEAR >1990; I get a 1064 error with using this code.I am using the MySQL console on WAMP SERVER v 2
View Replies !
Connecting Java With MYSQL In Wamp Server
import java.sql.*; public class Connect { public static void main (String[] args) { Connection conn = null; try { String userName = "root"; String password = ""; String url = "jdbc:mysql://localhost/test"; Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (url, userName, password); System.out.println ("Database connection established"); } catch (Exception e) { System.err.println ("Cannot connect to database server"); e.printStackTrace(); } finally { if (conn != null) { try { conn.close (); System.out.println ("Database connection terminated"); } catch (Exception e) { /* ignore close errors */ } } } } } I have doubt that it is happening since MySQL is in C:wampMySQl.?? This is the output of StackTrace(); java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at Connect.main(Connect.java:14)
View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server. If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields? In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names? Or do they matter?
View Replies !
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for MySQL" in connection page I put Linux IP address as "Server host" and username/password I keep getting error: Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061) My question is: Do I need a client installation or configuration on Windows machine?
View Replies !
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it. When i try to connect the ODBC allways returns the following error: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001) I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc... The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.
View Replies !
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net. Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine So please tell me process 1 have to simply upload my mySql database in Public Html folder or else where i m using cPanel file manager to upload files
View Replies !
I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I think the right command is mysqld_safe --user=mysql but during the starting procedure the server shutdown, it reports: [root@psiche root]# mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 040525 09:32:25 mysqld ended If I try to rebuilt the grant tables using the mysql_install_db it reports some errors: "asked for 196608 thread stack, but got 126976" and "to start mysql at boot time you have to copy support-files/mysql.server to the right place for your system".
View Replies !
Building A Db On Another Server From A Linux Machine
I'm running wamp on a XP machine, which is where my DB will be located. I want to be able build a file containing a crapload of inserts on my linux machine. Is there an easy way to execute those inserts on the DB on the windows side? I guess I could write a small PERL routine to open a connection, and send each insert line by line, then exit. But is there any command line routine that can run on linux (fedora 5) that can initiate the connection, then pass it the file of inserts? I'd like it to be command line, so it can be run from another application which would then run this from a shell.
View Replies !
Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql. The file contains around 30000 data but after i've typed: mysql> source /xx/file_name.sql; Table of the sql file is created but contains no data. But it poped an error notice without any message: ERROR: <----like this the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?
View Replies !
Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting. I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.
View Replies !
Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux ) WHM 11.11.0 cPanel 11.16.0-S18450 REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0 after update apache then all websites on server can not connect mysql from WHM > Tweak Settings > Mysql > 5.0 and used old style (4.0) passwords with MySQL® 4.1+ also command /scripts/mysqlup but no way still same error can not connect to Mysql
View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Replies !
Windows Mail Server
I'm curious what mail server is reccommended for interaction with mysql on windows. Our basic requirement is to have the mail client send e-mails based on addresses in the db (not spamming - for password resets, etc).
View Replies !
Connecting To A Server From Windows XP
I have installed MySql 4.1 on my windows XP home computer. I would like to connect to my university's server, but when I start the program, it automatically asks me the password, then connects me to my own home server. How can I connect to the other server?
View Replies !
MySQL Server For Windows
I have Windows-2000 Server with IIS-5.0, PHP (4.3.0) and MySQL (3.23.55). There are about 4000 users with their MySQL databases. Users can access databases using their PHP scripts. Only local users are allowed. To create a user I use this command: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `User_database` . * TO 'User'@'localhost' IDENTIFIED BY 'Pass'; The problem: after 3-4 hours of work, all users getting the error message: "Can't connect to MySQL database at localhost (10061)". I can't connect to MySQL using mysql.exe with admin username and password too! But MySQL service is still running! Restarting of MySQL service gives no result. Restarting of IIS gives no result. Code:
View Replies !
How To Target 1 Of 2 Servers On The Same Windows Server
With the end of the year came the time to do upgrades on my server. I try to stay back a revision in conservative fashion. So MySQL 4.11 was upgraded to 5.0 then 5.1 on Dec 31st. We just found out that one of our clients sites can not work with 5.1 so we rolled back to 4.11 But MySQL allows you to run multiple SQL servers without problem on the same server. So 5.1 was reconfigured to run on a different port than default. Now I have phpMyAdmin with two configurations able to access both DBs. The question is, How do I target one DB or the other with my scripted pages? Connection string? IIS config based site to site or based on the ext like PHP files will use one port and .ASP files will use another?
View Replies !
MySQL & Windows 2003 Server
I have a windows 2003 server running a MySQL server on it presently. This is a Test Box. Is it possible that I can also have an instance of Microsoft SQL Server 2000 running along side the MySQL Server at the same time?
View Replies !
MySQL On Windows 2000 Server
I want to install MySQL on to a Windows 2000 Server, I also want to remotely manage it using MySQL administrator, so connecting to the server using its IP Adderss, On windows workstations if you try and connect to the MySQL database from a remote mechine it does not allow you to do it (I have disabled all firewall's etc.). Do you have to install a server version and not LOCAL version of the MySQL server?
View Replies !
Unable To Use ODBC On Windows Server
I use to be able to connect to mysql on my testserver...this was through ODBC. Now for some reason, I cant connect to the testserver threw ODBC anymore... And when i get the error it says im trying to access the local host.. Heres a Picture of what i get: http://img28.picoodle.com/img/img28/4/7/8/f_WTF2m_00b267b.jpg I can still connect to "other" servers correctly.. I tried reinstalling myODBC on the windows machine... also I tried: GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.my.comp'; FLUSH PRIVILEGES; when that didn't work i tried GRANT ALL PRIVILEGES ON *.* TO 'root'@'*'; FLUSH PRIVILEGES;
View Replies !
MySQL On Windows Server 2003
Is it a good idea to use MySQL on Windows Server 2003 as a good alternate than Microsoft's SQL Server? I've never used MySQL before, could someone tell me how close it is to SQL?
View Replies !
Connecting To Mysql Server On Windows
I am trying to use mysql on win98 I downloaded mysql control center. I fill out the info it asks for and it shows it registers the the server but then I cannot connect to setup my db. heres the info I put in. name:upload host:localhost username:root password:****** Ihave tried stopping and restarting everything. I used the default install settings for mysql.
View Replies !
BLOBS Not Working On Windows Server 2003
I have been using Windows Server 2003 to host my own websites, last weekend I finally gathered courage enough to install linux mandrake 10.1 instead. After tow painfull but rewarding days I finally installed everything and was up and running in a LAMP config, sice I developed all of my sites in WAMP everything was ok... BUT BLOBS ARE NOT WORKING AS THEY ARE SUPOSSED TO...
View Replies !
MySQL Service Keeps Shutting Down In Windows Server
Strange, MySQL has been running smoothly for almost a year on this server, and just recently it shuts down after boot up. Running Windows 2003 with all patches. Any attempts to restart MySQL results in shutdown of the service. This is the Event error message: "TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS" Here is the log that shows the shutdown... Code:
View Replies !
Cannot Start MySQL Server Other Than Using Windows Service
I already learn how to install, starting and stopping server using Windows service, as well as the SQL query. I couldn't start the MySQL server using command-line. I could stop it using command-line by invoking "mysqladmin -u root -p shutdown". When invoking "mysqld --console" There was an error code number 5 that said "InnoDB operating system error number 5 in a file operation". What happened ? As an Additional information, I use Windows Vista SP1 and MySQL 5.1.30-community
View Replies !
Remotely Connecting On Windows Server 2003
This is probably answered somewhere but I can't find it. I have MySql 5.0 installed on a Windows Server 2003 box and it's working fine. I can connect to it via MySqlAdministrator, MySqlFront and Helm Control Panel which are all installed on the same box. When I try to connect via a remote machine I get an access denied error. What can I do to connect remotely?
View Replies !
Installing Mysql On Windows Server 2003
i have installed mysql 5 on windows server 2003 and when i want to connect to the database throgh my script it gave me this error Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Inetpubwwwroot estdefault.php on line 9 Couldn't connect to server. why it is like this. what i have to do and also i can access the database from Mysql command line client....
View Replies !
Lost Connection To Mysql Server During Query (Windows XP)
I have following problem: when I try to connect from Windows XP to mysql server (linux computer), I get the following error: Lost connection to mysql server during query. This happens when I test the connection. I have firewall in linux, so I opened the port 3306. Is there something else I need to change to make sure that the connection will work properly?
View Replies !
ERROR 2006: MySQL Server Has Gone Away On Dos Windows Client
I keep getting connection lost errors from a DOS windows mysql client on Windows 2000 from which I access a MySQL server (3.23.58) on RH9 (located on a dedicated server outside the country). ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... SQL statements are okay, tables are okay but whenever I stay idle for a few seconds, I get an error. If I retry, I get a reconnect and everything goes well... Then the same thing happens again.
View Replies !
Trouble Connecting To MySQL On Windows Server 2003
Fatal error: Call to undefined function mysql_pconnect() <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connMySQL = "localhost"; $database_connMySQL = "database"; $username_connMySQL = "root"; $password_connMySQL = "mypassword"; $connMySQL = mysql_pconnect($hostname_connMySQL, $username_connMySQL, $password_connMySQL) or trigger_error(mysql_error(),E_USER_ERROR); ?> I installed the ODBC drivers as an optional solution, and that appears to be working when I test it within the program, but I don't know how to get my .php website to connect to it. .php files are working correctly on the server, but it's just not connecting to the database.
View Replies !
Mysql 5.1 Windows Realease Server Starting Problem
I am a new user to MySQL, and I have run into difficulties starting it. I have successfully done this once a while back, and than had to go away for a while. I am now trying to start the server again via the windows command line. I type: "C:Program FilesMySQLMySQL Server 5.1inmysqld" as directed from section 2.3.10 of the user guide and nothing happens. It just returns C prompt. I then use "C:Program FilesMySQLMySQL Server 5.1inmysqld" --console; this gives screen output as I do not get a data directory with an error file without '--console' The output is: 090419 17:30:38 InnoDB: Operating system error number 5 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. It may also be you have reated a subdiretory InnoDB: of the same name as a data file. InnoDB: File name .ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. And then goes back to C prompt on the command line. Can anyone help me? If memory serves, I followed the user guide to the letter when I started (save for the post-startup material). As well (and possibly related), I have the mysql command line client in windows on the desktop (c:program filesmysqlmysql server 5.1inmysql.exe). I click this and it prompts me for 'enter password'. I don't ever remember entering a password the last time which may be related to the first problem staring mysql server from the command line.
View Replies !
How Do I Start Logging On Windows Live MySQL Server?
As I understand it, the server has to be shut down for the logging to be successfully started. Is this correct? I have been experimenting on a local MySQL server to make sure I know what to do on the production server. My production server has a my.ini file at the location c:Program FilesMySQLMySQL Server 4.1my.ini with various config stuff in it. Would it be ok for me to add the following under the [mysqld] part of the file: log=/logs/mysqld.log Thus creating a file named 'mysqld.log' in the folder 'logs'. The main things I need to log are the SQL Statements being executed and the IP Addresses/hostname of the connections. What type of log would be best for this? Also how do I make it so that the log doesn't grow ridiculously large?
View Replies !
Can't Connect To MySQL Server On 'localhost' (10061) On Windows 98
i'm a newbie here and i've just installed the apache,php,mysql package on windows 98 i started the relevant batch file and i'v sucessfully entered the phpdev5 home page however when i clicked on the phpmyadmin link it issued this message: Warning: Can't connect to MySQL server on 'localhost' (10061) is it because of the os i'm using or is there something in my system that is conflict with the installation? appreciate if you could reply soon as the start of my work depends on this.
View Replies !
Can't Connect To MySQL Server On 'localhost' (10061) On Windows XP
I just set up a test environment on my local machine. Windows xp pro sp 2 Apache 2 php 5.2.0 MySql 5.0.27 I can connect from the console and run queries just fine but from a php page I try to run. $link = mysql_connect('localhost', 'root', 'my_password'); And it says Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:Apache2htdocsmysql.php on line 3 This doesn't seem to be a php problem because the phpinfo() shows mysql just fine and the mysql_connect is recognized as a function. The password is the same as the one I use when connecting from the console. Any idea what I could have done wrong? Reading Yank's book I can't figure out what's wrong.
View Replies !
|
TRACKER
