HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free and registered users see less advertising! If you just want to browse through the existing questions, just select the forum that you want to visit from the selection below. Otherwise, click here to register!. We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Hopefully quick q on MySQL

Okay, I got some tables I am going to have accessible that I want to have multiple users have full access or just read access to. I have fallen into a portable hole. How do I create users and allow them to access the system?

But when I try to login you see what I get. Any ideas? I wanted to use MySQL GUI to start filling up some tables. MySQL GUI wont connect either. Even if I try to use login root. I figure maybe you guys have a clue as to where I am screwing up.

Re:Hopefully quick q on MySQL

BTW, do you know of (for any sql for that matter on linux) a good data entry tool for databases, or a way I can fill in my data in ... say a spreadsheet ... and import it to a MySQL database?

What my goals are is as follows ::

I would like to simplify the pen and paper and model BattleTech (tm) game into a Freeciv ish type game for linux. Now, after much dleiberation, I have decided that all of the weapon range/damages/weights and battle mech stats should be dumped into a few tables. And have a separate one for each players' arsenal. For starting out, I will need to enter in all of the mechs and weapon info from each technical readout book I own and the rules compedium.

Needless to say I will have for just each the battlemechs' around 50 entries (give or take). This is nto soemthing I feel liek manually entering on the cli ;D

Any ideas? I really hate to say it -- but using a few simple forms and MS Access is a really simpel way to enter it. But I hate the MDB viewer that is currently out (sucks is a gentle word) so transporting the data is not really an option there ... Dilemmas dilemmas ....

Re:Hopefully quick q on MySQL

ok first you need to see if your version of mysql has loadlocal infile support. so create a .txt file and put some info in it with tab between each field. so for example if your table has three fields:

vim test.txt

test&lt;tab&gt;localinfile&lt;tab&gt;support

&lt;esc&gt;
:wq

then open up mysql and the table you will be loading the file into. then issue the command:

Re:Hopefully quick q on MySQL

Re:Hopefully quick q on MySQL

glad i could help. i found that out when i was looking at making a mysql4 package for the unofficial tree for Arch Linux. it is far more logical way to enter a large amount of data. kinda makes me wonder why they hide it so far into the documentation. for me it made my search for a frontend end because none of the frontend i looked at seemed to offer what load local infile does. mysql is easy to manage once your mass of data is entered.

Re:Hopefully quick q on MySQL

[quote author=sarah31 link=board=2;threadid=6354;start=0#60553 date=1045852715]
glad i could help. i found that out when i was looking at making a mysql4 package for the unofficial tree for Arch Linux. it is far more logical way to enter a large amount of data. kinda makes me wonder why they hide it so far into the documentation. for me it made my search for a frontend end because none of the frontend i looked at seemed to offer what load local infile does. mysql is easy to manage once your mass of data is entered.
[/quote]

Yeah, I gotta agree, the frontends for the mostpart suck. I really wish some talented group would make a frontend to MySQL and PostgreSQL that imitates MS Access. Where Access fails, MySQL whips its ass. All our SQL dbs need are really useful frontends like that.

After learning Access, I found a whole shitload of things I could do that seemed way too difficult at first. Now I want to do similar things, but had/still-have a rough time. At least the load local inline is a breeze.