IT Team : Help with MySQL

[Keith Lawrence(BSAC)]

Anybody out there who could give us a hand setting up MySQL on our web server? It?s all installed and running but none of us are experts with MySQL, it?s all basic stuff like ?

+ How do we set up databases?
+ How do we set up users?
+ Is there a web interface we can use to admin it?

I?ve had a quick look on the web but it?s difficult to find a quick and concise users guide (the MySQL .pdf users guide is over 1,000 pages!). Somebody who knows about this stuff and could give us a hand would be most appreciated.

Email me if you can help and donate a few hours of your expertise to the club.

Thanks All

Keith Lawrence
BSAC Council Member
BSAC IT Team Leader

[DeepDigit]

Anybody out there who could give us a hand setting up MySQL on our web server? It?s all installed and running but none of us are experts with MySQL, it?s all basic stuff like ?

+ How do we set up databases?
+ How do we set up users?
+ Is there a web interface we can use to admin it?

I?ve had a quick look on the web but it?s difficult to find a quick and concise users guide (the MySQL .pdf users guide is over 1,000 pages!). Somebody who knows about this stuff and could give us a hand would be most appreciated.

Email me if you can help and donate a few hours of your expertise to the club.

Thanks All

Keith Lawrence
BSAC Council Member
BSAC IT Team Leader
-------------------------------------------------------
I know a bit I did some Ingres app development when I was a software engineer - is it a Windows or Linux server? What you going to use it for?

createdb - creates a database
the rest you need to be connected into the db at the command line to create tables and rules.

you should be able to run the command mysql in the Mysql/bin folder... type help for help

Our club website uses MySQL on our own Win2K IIS5 webserver..

Theres a tool called mysqlgui I think its on the MySQL site - its been a while since I've grabbed a copy..

<a href="http://www.mysql.com/downloads/gui-mysqlgui.html" >http://www.mysql.com/downloads/gui-mysqlgui.html</a>

It provides a windows interface to it - you have to be a bit switched on with sql syntax - but you can add users and dbs and permissions and passwords and stuff.

<a href="http://www.mysql.com/documentation/index.html" >http://www.mysql.com/documentation/index.html</a> theres some sql good documentation.

there are also some nice tools to convert and uplaod Access Dbs to MySQL... Best to use this method first, it by intelligent converters <a href="http://www.convert-in.com/" >http://www.convert-in.com/</a>

The tricky bit can be setting up DSN for the ODBC sources for the apps... Dreamweaver has some built in which is quite nice

It looks like you have some long late nights ahead of you, its hard work, learn sql and how to drive Mysql and integrate into web apps maybe, why not stick with Access? Relational Db are such hard work, lots of normalisation, data models and stuff - sheesh its enough to make your head hurt.

Seem like your in deep water
Good Luck ;-)

[Keith Lawrence(BSAC)]

Thanks for the pointers folks (and those who emailed me). It's the DB on our web server, a Sun Linux box that we want to get going properly. I'm more than happy with DB's (I'm a DBA) it's just the MySQL engine that I'm not familiar with - I know WHAT needs doing it's the HOW on MySQL that is missing :-)

But we're getting there, pointers to recommended tools and documentation have helped. It's not for HQ - we've got a SQL Server there on our intranet and I know how they work...

Cheers

Keith L

[Adrian Kelland]

Keith

If you are wanting to use transactions (thinking rollback etc? ), the mySQL default table type does not support them. You would require innodb type IIRC. Just an issue I came across in the past.

I have dabbled with mySQL in the past, and am just starting to do so again. If you fancy a partner for bouncing problems off, I'll give it a try.

I'm no good with Linux though :( Just struggling with my first Linux server. Now where's my 'Linux for complete numpties' book...

Adrian

[neil carter]

Hi Adrian,

-&lt;&gt;

Probaly in the same filing system as my "HTML for complete numpties " book - Why do we spend so much time on these damn "time saving!!" computers when we could actually be DIVING???

I'm sure someone must have already promulgated this as fixed law #x of IT dynamics, but why is it that the more you learn about computers the less you know???

Best

Neil

[Matt]

Probaly in the same filing system as my "HTML for complete numpties " book -

Why do we spend so much time on these damn "time saving!!" computers when we could actually be DIVING???

LOL. If I didn't spend so much time with computers I could not afford to go diving. After the 73 hours I put in last week, I actually enjoyed the dip in Vobster yesterday!

I'm sure someone must have already promulgated this as fixed law #x of IT dynamics, but why is it that the more you learn about computers the less you know???

AIUI the more you know, the more people know you know, and the more they expect you to know what they do not know, whether you should know or not, but you know you do not know. So the more you know the less you know. Simple really :-)

[Vic]

&gt; Why do we spend so much time on these damn "time saving!!"
&gt; computers when we could actually be DIVING???

'Cos if you didn't, some of us would have to work for a living ;-)

Vic.

[terryh]

I actually enjoyed the dip in Vobster yesterday!

Tell you what, we are going to have to rubber stamp names on
foreheads or something. I was there with our little group well.

Rgds
TerryH