Reg MySQL Server Work As Local Network Or Remote Server
I installed mysql-5.0.51b-win32 version.How to configure in MySQL server work as local network or remote server.PostgreSQL we did configuration in pghba.conf host all all 0.0.0.0 0.0.0.0 md5.How we can do settings in MySQL 5.0 server.
View Complete Forum Thread with Replies
Related Forum Messages:
Server On The Local Network
I am new to mySQL and am studing computer sciences. For a project we need to create a database, upload it to server provided by the university and access the database via an application from any computer on the university network. My question is how do I upload the sql file to the server?? I tested the database on my pc(localhost) and it worked. Now I tried to upload it onto the server. I did the following: opened command prompt and went to the mysql monitor. I entered the command: mysql -h (the server address) -u (username) -p Then I pressed enter and entered the password I got a massage that said that I am connected to the server. Now I don't know what to do. I have the sql file that needs to be uploaded to the sever, but I am not familiar with sql commands. I have searched on google, but nothing they gave me worked.
View Replies !
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
Mysql Server On A Remote Server
I have recently installed a mysql server on a remote server machine. It has 197.0.3.57 ip address assigned to it, and i believe the port it is using is 3306. I have also installed a mysql command line client on my PC, and successfully launched it. Now i have: Enter password: But how do i get connected with the remote mysql server, it seems the system is asking me to enter localhost password. What sort of client package shall i install other than commnad line client if any? and what command shall i invoke to get me connected?
View Replies !
Unable To Connect MySQL Server Across The Network
We have a MySQL server that was managed by another group in our company, the guy who used to manage that MySQL server has promptly left. Now this server has turned into me. I'm a Microsoft SQL guy, however, the manager doesn't think there is much difference between MSSQL and MYSQL. Now I am in the hot seat to fix a problem that just occurred last week. We're suddenly not able to connect this MySQL server across the network. I checked the network connection, everything looked fine, I was able to telnet into the port 3306. First I thought someone changed the root password, but I was able to connect the server from the local server by using: mysql -h localhost -u root -p Other accounts have the same problem as well. If I try to connect this MySQL server from a workstation, I'll get the following error message: ERROR 1045 (00000): Access denied for user: 'root@CS7LL11' (Using password: YES) It will be geatly appreciated if someone can inform me what I need to do to fix this problem. By the way, this MySQL server has the version # 3.32.56-nt
View Replies !
Mysql Server Wont Work
i am having mysql install with Plesk 7.5 for windows and yasterday the mysql server wont work everytime i click to start it stop in same sec how can i solve the problem and did that will make m elost my db ?
View Replies !
Connect To Local MySQL Server
I am trying to connect to our remote MySQL server (which is running just fine). I have a perl script which worked just fine on my other Fedora 4 box (all servers are Fedora 4 with latests updates). The one that worked fine it down and I cannot compare anything against it (it was a client also). My problem is, when I try to connect to the server I get: DBI connect('passwd','user',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /home/perl_inc/mysql.pl line 19 I read all the articles I could on the subject talking about how mysql.sock was in /tmp and linking it etc, but on my system I did: find / -name 'mysql.sock' and cannot find it anywhere on my system. My question is, on the mysql client, is there always a mysql.sock file?
View Replies !
Can't Connect To Local MySQL Server... :(
My site is getting very busy and I keep getting this error every few times I visit my site. I just hit refresh and the site loads, but how can I avoid this error from coming up? Do I need a separate mysql server? Or apache has too high loads? What is causing this? PHP Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in
View Replies !
Can't Connect To MySql Server On Local Host
When I installed MySql on the Windows 2000 Proffessional ,it works fine.But I followed the same installation steps in Windows 2k Advanced Server.It gives me this error "can't connect to MySql server on local host".It says failed to start service . I couldn't find any mysqld.exe file in the processes list of the Task manager window. Please tell me steps to get mysqld.exe file appear on the task manager. Kindly let me know the way to get mysql running.I have the Operating System on E: drive of my computer.
View Replies !
Choosing A Version Of MySQL For Local Web Server
In the process of setting up a localhost web server to test things before I put them on my shared host server. Mostly I'm just dabbling - not making a living at it. My server is Apache 2.2.3 with PHP 5.2.0 on WinXP-Pro. What version of MySQL is most compatible with these versions of server software? Can someone point me to an installation how-to doc? Would also appreciate pointers to pages I should read to familiarize myself with MySQL. I've dabbled with dbs's as standalone apps but never used one on a server before.
View Replies !
Can't Connect To Local MySQL Server Through Socket
I am running ubuntu 8.10 with mysql server 5.0.67ubuntu6. When I try to login locally I get the following error: glen@glen-laptop:~$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) glen@glen-laptop:~$ It looks like the mysql daemon is not running. When I try to run it I get the following error: glen@glen-laptop:~$ sudo /etc/init.d/mysql restart [sudo] password for glen: * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [fail] glen@glen-laptop:~$ I use to have this working fine. But I have somehow managed to break it. I have tried purging mysql and re installing it but I still get the error?
View Replies !
Can't Connect To MySQL Server On Local Machine
am following along in Head First's PHP & MySQL book, at chapter 2. I've downloaded PHP, MySQL, and Apache. A couple basic scripts have worked fine, so I know PHP is working. I can create a table and a database in MySQL throught the command line window, so that seems good. But I'm trying to execute an INSERT function on the example table that the book had me make, using a script, and I'm getting "Error connecting to the MySQL server" which is the or die error message I used for failure to connect. In setting up MySQL, I was prompted for a password but not a username. So I'm trying to leave the username data blank in the mysqli_connect function. I wonder if this is my problem? I've looked through my.ini but to my untrained eye it's all Greek and I can't spot usernames or passwords there, or in any of the other .ini files in the MySQL folder. If I need a password, can anyone tell me how to find out what it is? Here's how I wrote the connect function (username is blank, surrounded by single quotes): $dbc = mysqli_connect('localhost', '', 'password_here', 'databasename_here') or die('Error connecting to MySQL database.');
View Replies !
Server - Network Access
I'm developing a database application using MySql(version 5.1) & QT. In my application, a server machine contains the database & users connect to it using my application over the network. My question is using the user name & password given & using a third party mysql client, my users can connect to database & do whatever according to the privileges granted to their account.It is potentially dangerous in my case. Is there any method in MySql Server to limit clients to connect using only a specified application? In my case, users should be able to connect only using my application & they must not be able to connect using any other clients.
View Replies !
Phpmyadmin :: Cant Connect To Local Mysql Server Through Socket
i have recently installed & config'd mysql all seems to be fine with command line, however i have installed phpmyadmin and keep getting complaints about 'cant connect to local mysql server through socket /..blah/..blah' i have checked the php.ini file and everything seems to be in order i have been using webmin with no complaints, but would prefer to use phpmyadmin.
View Replies !
Can't Connect To Remote MySQL Server
I am developing a site on a remote cPanel system and I am not able to connect to the MySQL database from my location. My application can connect to the server using localhost just fine. I have ensured that the correct port is open in the firewall (the server responds to telnet on that port) and I have added our IP address as an access host in the MySQL area of the client's cPanel but I am still unable to connect. The exact error message when I try to connect is: Access denied for user: 'user@<my IP>' to database 'user_database'
View Replies !
Connect To A Remote MySQL Server On The LAN
The MySQL setup on my WinXP machine runs fine with host localhost, username root, and my password. But I can't seem to access my databases from a different machine on my LAN. When I try to connect from another network PC , I always get: MySQL Error No 2003 Cannot connect to MySQL server on 'remotehost' (10060) All the settings in my ini seem correct. I've allowed TCP/IP connections. I know which port to specify. Did I forget to do something on the LAN to allow remote access? I've tried sharing the basedir and datadir folders. That didn't work. I also tried using IPs instead of hostnames. Didn't work either. When I try to ping the remote host (using MySQL Administrator), I just get a timeout error.
View Replies !
Remote Connect To Mysql Server
My host says that I don't need to login to my server in order to connect to my mysql server. They say all I need to do is enter this command into a mysql client: mysql -h xxx.xxx.131.240 -u User -p Database Password However, they don't want to mention any client to use to connect with. What client can I use? Putty? Where do I enter that command?
View Replies !
Connect To A Remote MySQL Server
I need to connect to a remote mySQL server. I have the IP address, userID, and password. When I try using these from another computer I get an "access restricted" error. How do I get to this remote mySQL server?
View Replies !
Connecting Remote Server In Mysql
Waht is the way to connect the remote database in mysql? right now i am connecting it with localhost as server name but if i want to connect other datasource it showing the error datasource not found.
View Replies !
Connecting To A Remote MySQL Server
I havn't done this before and i'm not sure how to do it. I have another computer on a LAN that is running a mysql server and is the machine that is also running the intranet server which i am working on. What i want to know is how to connect to this server from my MySQL console so i can administer the databases without having to be in the main machine. I thought it would be as simple as using the IP address but this doesn't seem to do it. Can i connect annonymously like i can from the host or do i have to have a user account setup?
View Replies !
Connect To MySQL From Remote Server
I need to connect to a mysql database on another (remote) server. I've set up the user and granted all permissions, etc. and I can connect to it from some of my other websites, but not from the one I'm working on. Here's how I granted my permissions: Code: GRANT ALL ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON *.* TO 'user'@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; And here's how I'm connecting: Code: mysql_connect('66.246.229.94','username','password'); As I've said I've been able to get this to work on some websites, but not the one's I actually need it for. Here's the mysql_error() I get: Code: Can't connect to MySQL server on '66.246.229.94' (111) Here's the mysql phpinfo() for said site: Code: MySQL Supportenabled Active Persistent Links 0 Active Links 0 Client API version 3.23.49 MYSQL_MODULE_TYPE builtin MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE no value MYSQL_LIBS no value DirectiveLocal ValueMaster Value mysql.allow_persistentOnOn mysql.connect_timeout6060 mysql.default_hostno valueno value mysql.default_passwordno valueno value mysql.default_portno valueno value mysql.default_socketno valueno value mysql.default_userno valueno value mysql.max_linksUnlimitedUnlimited mysql.max_persistentUnlimitedUnlimited mysql.trace_modeOffOff The "MYSQL_MODULE_TYPE" and "Client API version"
View Replies !
Turning Localhost To A Network Server
I have a small home network with two computers. On my computer I am running MySQL 4.1.21-community as localhost. I have only be using this for development work. My husband wants to learn SQL so I would like to be able to have Mysql Query Browser installed on his machine, with him accessing all the databases I have set up on my machine. How do I go about giving him access to my databases? My machine runs Windows XP and his runs Windows 2000.
View Replies !
ERROR 2002: Can't Connect To Local MySQL Server Through Socket
i get this when i do '/etc/rc.d/rc.mysql start' ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) ive had a look on google, and the problem for most people seems to be permissions, but im running as root, and the socket doesn't exist. It doesn't create the socket when it runs, because i tried putting mysql in the root user group. i do have a script that clears the /tmp on login, but i dont think that would affect it,
View Replies !
Error 2002: Cant Connect To Local MySQL Server Through Socket
Well that's the error I'm getting when trying to connect to my MySQL database, more specifically: Error 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I know the PHP is fine because it's a straight copy and paste from a site I wrote before that's working fine (on the same host as well no less), anyway I did a bit of Googling and all the results that came up said that it's a configuration issue and can be resolved in several ways (mysql daemon, the my.cnf file etc etc) only problem is I'm on a shared hosting service so I don't have access to this. Does anyone know of any other potential cause to this problem other than configuration issues or is it just a call up the host deal?
View Replies !
Merging Data On Remote MySql Server
I've been tasked with installing the table structure from the master database onto a remote MySQL server. The remote server will accept data and periodically, merge/dump the data to the master server. I need help with the merge/dump issue. This doesn't sound like a replication (where two database servers are made to look identical) issue but 'merge' doesn't soud right either.
View Replies !
Insert Records To Remote Mysql Server
for a insert statement, there are two packets on the network between the client and the server. so, the packet's number will be double of the number of insert statement. that is rough. I want there will be a few packet used for many many insert statement. Is there any way to make that true.
View Replies !
Remote Access To MYSQL Server Host
I am trying to access a mysql database on my old host (I'm doing a CMS migration to something on a different server.) My hosting company doesn't have a CLUE what I'm talking about when I say MYSQL server host (I'm not even sure I do). They keep telling me it's 'localhost'. I can access both dbs through their prospective phpmyadmins. Is there any way I can find out what the host server is? I would just export the db and then import it into the other one, but all attempts at that have failed.
View Replies !
Accessing A Mysql Database On A Remote Server
i would like to know how to connect to a remote mysql server which is on linux from a windows system. I gave the command: mysql -u root -p redhat -h 192.168.1.132, where the ip is the ip of the linux server. But i got the error message stating that :- Host 192.168.1.114(which is my system ip) is not allowed to connect to this MySQL server.Sreejith
View Replies !
Mysql On Local Network
Is there a way to share mysql on a local network? Both computers running IIS on Windows XP Pro. Both have php running, but using a root website folder on another computer (main server). Both are running PhpMyAdmin, but we are getting our own MySql database showing up. I want us both to get access to one MySql server. We both access the website using http://localhost
View Replies !
Remote Access :: Can't Connect To MySQL Server On {IP} (10061) In ..
I am facing problem when i try to connect to a remote mysql server using mysql_connect command. It give error " Can't connect to MySQL server on {IP} (10061) in" I have even added one user and gave it permission to connect from any host (%) and allowed DB rights too. I have checked that mysql variable -skip_networking is also off. There was fire wall installed on mysql server but that has been removed but still problem is not solved.
View Replies !
Localhost Mysql Connection Pointing To Remote Server!
This one is beyond bizarre. For a few days I've been having trouble working on my site on my local machine. Everything was dog slow, and the information I was seeing coming out of the database was oddly out of date, even though I had synced to my live server several times. I finally discovered that the records I was seeing were consistent with the tables I have up on my Media mysqlle host, which I've been working on switching over to, but is not live yet. So to put it more clearly, when I'm running my local version of my site on my local version of Apache (on my Windows Vista laptop): 1. The php files being interpreted are indeed the ones on my local machine. 2. Any MySQL queries somehow reach up to Media mysqlle, and query THAT database (even though it has different login credentials). I'm using the following lines to create the MySQL connection: $sqlHandle = mysql_connect('localhost', '<myusername>', '<mypassword>'); mysql_select_db('<mydatabasename>', $sqlHandle) or die(mysql_error()); Is this weird, or what? Any idea what's going on?
View Replies !
Connecting To Remote Mysql Server Using Web Based Php Script
I am trying to setup wordpress software and trying to connect to mysql database located in remote host. I kept getting an error saying that 'we can't connect to database server specified in DB_HOST field of php code' how to make wordpress software's remote connections to mysql server located in a remote host
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
Connecting To A Remote Mysql Server From A Java Application On Another Machine
i've a java application on a (remote/network) machine and mysql running on my local pc.other users who have access to that remote machine must be able to run that java application which will have to get data/send data to the server(/DB) on my local PC. i was able to run the application when its on my local pC using localhost in the connection string. But, now how do i set the connection string so that the java application accesses the DB (/server) from my local PC?
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling from source. When I try to run MySQL, I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' After much searching on Google, and reading many newsgroup threads on this error, as well as reading the manual, I'm still stumped. Most of the advice I've found suggests that the path to mysql.sock is wrong, which makes sense, but I don't have the file mysql.sock anywhere on my machine, so obviously I can't correct the path.
View Replies !
|
TRACKER
