• Connect to MySQL on different machines

    I recently installed MySQL on a Windows Server on our domain. But we're having issues connecting to it from our other machines on the domain. I just opened the MySQL administrator panel to change the connection but it's still not recognized. What should we do?

    ITKE970,820 pointsBadges:
  • Fix MySQL error 2003: Can’t connect to server

    On MySQL, I keep getting this error message: Error 2003 - Can't connect to MySQL server on 'server name'. Has anyone gotten this before? If so, how do I fix it?

    ITKE970,820 pointsBadges:
  • MySQL features and benefits

    What are the features and benefits of MySQL?

    sweetpeajd110 pointsBadges:
  • Connect DBI to MySQL database without password

    In DBI, I'm trying to connect to our MySQL database as a user without a password. Is that possible? Basically - I just want to grant access to myself without having to put in a password.

    ITKE970,820 pointsBadges:
  • Check dropped MySQL database connections

    One of our clients uses PHP to connect to MySQL. Now, for security reasons, both the PHP scripts / MySQL DB are on two different Linux servers. Now, they're saying that the database connections keep dropping out / timed out. Is there a way to see in MySQL if that's true? We already checked the...

    ITKE970,820 pointsBadges:
  • Uploading CSV file data into MySQL database automatically

    Would I be able to upload my data, that's in a CSV file, into a MySQL database automatically? I need this because the database has to get updated from a path folder. Can anyone help?

    ITKE970,820 pointsBadges:
  • Connecting MySQL database to another computer

    I recently created a MySQL database and it's using localhost as the host. Now I need a co-worker to do some testing but I'm not sure how we can connect to it from another machine. This is also on Windows 7.

    ITKE970,820 pointsBadges:
  • Connect Android application to MySQL Server

    I recently created an Android application and I'm trying to connect it to my MySQL server. Is there a way to do that? Someone told me to use JDBC - should I go that route? Thank you very much.

    ITKE970,820 pointsBadges:
  • How to find MySQL username

    I need to figure out what my MySQL username is. Whenever I'm using the command line client, all it asks for is my password. That's it. And I can't remember it at all. Can anyone help me out?

    ITKE970,820 pointsBadges:
  • Import Microsoft Access database into MySQL

    I'm currently on a Windows machine with a Microsoft Access database. I need to import that into MySQL on another Linux web server. Here's what I'm doing right now: Exported as text file Copied with FTP Loaded into MySQL Is there a better process for this? Any help would be appreciated.

    ITKE970,820 pointsBadges:
  • How to check if a table exists in MySQL server

    Hi, To connect to my MySQL server, I've been using an ODBC connection. Is there a way to check if a table exists in my database? And if it's not there, how can I create one?

    ITKE970,820 pointsBadges:
  • How can I escape all CRLF chars in all column values when doing a select?

    Let's say I want to do: SELECT * FROM tableName But some columns' values have linebreaks, so in my MySQL console it breaks the formatting of the table. I know I can circumvent this by explicitly REPLACE()ing CLRF chars, but this requires me naming each column and is not very quick to type out, eg.:...

    hazzlewis5 pointsBadges:
  • Storing PDF files in MySQL as BLOBs

    Experts, Can you please help me? I need to store several PDF files into MySQL as BLOBs. How can I do that using PHP? You are the best!

    ITKE970,820 pointsBadges:
  • How can I load CSV files into MySQL Workbench?

    I have several CSV files that need to be added into my database in MySQL Workbench. Is there a way to load them in? Is there a specific command I should use? Any help is appreciated.

    ITKE970,820 pointsBadges:
  • Is MySQL table supports both foreign keys and partitions?

    I have one table like employee (emp_no,emp_name,dept_id). This table contains the foreign key relation with deportment table (dept_id). Now I want to do partition on emp_no field in employee table. Is it possible or not?

    lakshmilogica15 pointsBadges:
  • How to show progress of CSV file to MySQL upload

    My CSV file is very large (Millions of files) and I'm currently loading it into MySQL. I'm using the LOAD DATA INFILE command. But I feel that this is taking way too long. Is there a way for me to see the progress of the upload? I tried SELECT COUNT(*) but it keeps giving me a 0 count. What should...

    ITKE970,820 pointsBadges:
  • Export/Import database with large blobs in MySQL

    Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing...

    jailall101785 pointsBadges:
  • Data synchronization/integration between two web applications

    Real time synchronization of two web applications is required. The scenario is that there is an E-commerce website which will display a super market products on its website plus E-commerce website has its own products too. The super market's  inventory management system will be in real  time...

    maha1235 pointsBadges:
  • Upload image from Excel sheet into MySQL

    How can I upload image from my Excel sheet to MySQL Database?

    BatulBohra5 pointsBadges:
  • MySQL 5.7 database: Table has crashed and last repair failed

    I have MySQL database, but two days ago, I stumbled upon an issue - Table is crashed and last repair failed. I don't know how to solve this issue. I need to get MySQL recovery tool.

    heraturs15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following