Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 7th, 2007, 06:07 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to neil.abachi07
Default MySQL database

Hi, i am designing a website and have created an ASP login page creating a connection to a MS Access database.

Everything was fantastic until the hosting company refused to support access! What tools do i need to create a MySQL database and the connection in my login page?

Thanks

Neil

 
Old March 7th, 2007, 09:24 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Depends.

If you want to the ability to create stored procedures and views, you will need to download MySQL Server v5.0+
If you do not need the above functionality, any version below 5 will work.

After you install MySQL you have 2 ways to administer it
1.The Linux/Unix way via a command shell
2.Download the MySQL GUI tools from mysql's website.

The gui tools used to be independant downloads, but they have rolled them into one suite of tools, but I can't remember the name of the suite. In any case, do a search on the mysql site for Query Analyzer and MySQL Administrator, that should give you the necessary download link.

Second, you will need to download the ODBC drivers from the mysql site (version 3.51) and install it on your machine and also make sure that it is installed on the server.

Third, this is the connection string.
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database= myDataBase;User=myUsername;Password=myPassword;Opt ion=3;

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
 
Old March 7th, 2007, 09:28 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to neil.abachi07
Default

thanks for that - pretty chuffed off with hosting company really but thats for another day. Is MySQL easy to get along with?

 
Old March 7th, 2007, 09:32 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Its like any other RDBMS really but, if all you are used to is access, then yes its going to take some getting used to.

But really, its not that difficult to learn. (Be warned though, MySQL implements different specifications of ANSI 92 then Microsoft does so some of your queries that you have created might not work.)

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
 
Old March 7th, 2007, 09:36 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to neil.abachi07
Default

right, i did SQL and Oracle 9i at uni for 3 years is that is of any use?

 
Old March 7th, 2007, 09:41 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Well, there is no such thing as BAD expereince. ;]

In any case, you will notice little quarks between MySQL and MS SQL for example

EXEC storedProcedure will execute a stored procedure in MS SQL
CALL storedProcedure will execute a stored procedure in MySQL

But, by and large, SQL is SQL, you just need to get familiar with what MySQL implements and how it implements it.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
 
Old March 7th, 2007, 09:45 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to neil.abachi07
Default

i will go read!

 
Old March 7th, 2007, 10:00 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Let me know if you have any other questions

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
 
Old March 7th, 2007, 11:16 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to neil.abachi07
Default

thanks - i have installed MySQL Server 5.0, MySQL Administrator and MySQL Query Browser. The server is configured and running but when i go into the admin gui and connect, apparently my computer refuses the connection! i have set the host up as my PC's IP address and entered a username and password but nothing.

Any ideas?

 
Old March 7th, 2007, 12:10 PM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 115
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to neil.abachi07
Default

ok, i got through that, im trying to migrate my mdb using the migration tool and i get the following error:

Opening connection ...
Connection jdbc:mysql://localhost:3306/?user=n.holloway%40abachi.co.uk&password=rayban&us eServerPrepStmts=false&characterEncoding=UTF-8
The connection to the target database could not be established (error: 0).
ReverseEngineeringMysqlJdbc.getVersion :Access denied for user 'n.holloway@abach'@'localhost' (using password: YES)
Details:
com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:946)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:812)
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3269)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:11 82)
com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2670)
com.mysql.jdbc.Connection.<init>(Connection.java:1 531)
com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.es tablishConnection(ReverseEngineeringGeneric.java:1 01)
com.mysql.grt.modules.ReverseEngineeringGeneric.ge tVersion(ReverseEngineeringGeneric.java:121)
sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

i looked at the MySQL help and it told me i had to do some changes to my database which i followed very carefully and did but i still get this error







Similar Threads
Thread Thread Starter Forum Replies Last Post
MySql Database Problem surongama JSP Basics 0 October 16th, 2006 08:01 AM
Need Help Connecting to mySQL Database! jehchoi1 PHP Databases 6 April 21st, 2005 09:28 AM
MySQL Database Connection jayteee Dreamweaver (all versions) 0 December 11th, 2004 11:27 PM
MySQL database communication dssachdeva MySQL 3 September 12th, 2003 01:22 PM
Shifting of MySQL Whole Database. kengyiam MySQL 2 September 9th, 2003 03:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.