What is wrong with my native mysql connection? [closed]
I am running LibreOffice on Windows 8. I have installed the MySQL Connector 1.0.1 extension. I have a web application using PHP and MySQL running successfully on a Ubuntu 12.04 LAMP server. I am trying to use Base to connect to my MySQL databases on the server. Using the database wizard, I select "connect directly", I enter my database name and server name (I have also tried using the server IP address), I enter the User Name and password. When I test the connection, I receive the error "Invalid for this platform protocol requested(MYSQL_PROTOCOL_SOCKET)" and am unable to access the database. What could be the source of my difficulty here?
If you try to connect locally on your ubuntu server, does it work? Also, are you sure you aren't connecting via TCP/IP rather than sockets? Perhaps http://unix.stackexchange.com/questions/32134/how-can-i-determine-the-connection-method-used-by-a-mysql-client is a helpful link, and especially this http://unix.stackexchange.com/a/3213 answer