-
effectively using mysql for web development in knoppix
I'm very new to knoppix and linux in general. I've saved the configuration etc to my HDD already. I want to be able to program in php using mysql on apache in knoppix. I can start apache and mysql and the server and look at pages on localhost, got that far. My problem now is that I cant find out how to
a) be the root in mysql so I can create new users with priveliges
b) databases I make in mysql don't exist after rebooting
c) will be trying to logon as root (just read how here a minute ago) nex time
Why do I need this option? Windows XP is a $@$% because it seems to have an issue where MySQL won't configure so PHP can access it. The easiest answer is to do it in knoppix. When I figure out how Linux ticks better I'll put it on my HDD and voila.
Any help would be much appreciated.
-
I now know how to log onto Knoppix itself as root but am having the same trouble with MySQL.
As the user table in MySQL is read only how do I
## Get better access as root, ie grant options etc for users
I looked at the config files etc but they are all read only so how do I
## Reclaim control of file and configuration access. Chmod doesn't work in this case....
Thanks in advance for any replies as I'm a linux newbie bar for some minor unix commands from school one time.
-
Ok I've figured most everything I needed to know out from trolling the forum and experimentation - gasp!
Only thing is that mysql databases I make for development can't be saved, or I can't see how, if I jsut put them on the desktop and reinsert them next boot up then they don't link properly. Anyway that's cool. I'll get an old box from the other room and set it up on my lan as a local web server for development work now I'm a bit more confident.
Although nobody replied to this post with advice I thank those who read it with interest for taking the time.
http://www.nortypig.com
http://www.blog.nortypig.com
-
MySQL should work under Windows w/PHP. Apache would be the tricky part, but that's for another forum ... there are many ways to solve your problem:
a. You can edit the 'saveconfig' script in knoppix to include the MySQL datafiles and make sure they are restored when you reboot. The modified 'saveconfig' will be saved automatically.
b. You can have a script by which you copy/tar/gzip your data files to persistent storage back and forth.
c. Set up MySQL Replication. While you work, your Knoppix DB is the master and somewhere else in the network you can have a MySQL slave (maybe in a Windows box?). When you launch knoppix, just copy the replicated files from the slave PC and restart the MySQL Master.
The last one is probably overkill, but you'll learn a neat MySQL trick.
Regards,
-GN
Similar Threads
-
By transistortoaster in forum General Support
Replies: 2
Last Post: 10-08-2005, 03:49 PM
-
By rangalo in forum Games
Replies: 2
Last Post: 07-11-2005, 02:06 PM
-
By HCSS in forum The Lounge
Replies: 0
Last Post: 03-13-2004, 09:32 PM
-
By Coume in forum General Support
Replies: 5
Last Post: 08-06-2003, 06:42 AM
-
By xound in forum The Lounge
Replies: 1
Last Post: 04-15-2003, 07:06 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
![Extron RGB-160XI Analog Computer Video 60-378-01 picture](/store/img/g/acQAAOSw0rdcMWoG/s-l225/Extron-RGB-160XI-Analog-Computer-Video-60-378-01.jpg)
Extron RGB-160XI Analog Computer Video 60-378-01
$187.06
![NEW Aquarius+ Computer Signature Edition - 8Bit Retro System picture](/store/img/g/IlUAAOSwPmZlBzrJ/s-l225/NEW-Aquarius-Computer-Signature-Edition-8Bit-Retro.jpg)
NEW Aquarius+ Computer Signature Edition - 8Bit Retro System
$209.00
![Analog Computing The Magazine Atari Computer Owners February 1984 No. 16 picture](/store/img/g/WfwAAOSw7uBmVIro/s-l225/Analog-Computing-The-Magazine-Atari-Computer-Owner.jpg)
Analog Computing The Magazine Atari Computer Owners February 1984 No. 16
$12.00
![Vintage Gateway 2000 Computer Intellimouse PC Mouse Pad Excellent NOS Analog Era picture](/store/img/g/4EQAAOSwb5llJfBu/s-l225/Vintage-Gateway-2000-Computer-Intellimouse-PC-Mous.jpg)
Vintage Gateway 2000 Computer Intellimouse PC Mouse Pad Excellent NOS Analog Era
$17.49
![Macintosh SE, SE/30 air box picture](/store/img/g/8toAAOSwzl9f4qy2/s-l225/Macintosh-SE-SE-30-air-box.jpg)
Macintosh SE, SE/30 air box
$18.00
![Apple II V2 ANALOG VGA & Z80 PCPI Applicard Softcard PicoPal IIe Ralle version picture](/store/img/g/F7cAAOSwn8hlkYHJ/s-l225/Apple-II-V2-ANALOG-VGA-Z80-PCPI-Applicard-Softcard.jpg)
Apple II V2 ANALOG VGA & Z80 PCPI Applicard Softcard PicoPal IIe Ralle version
$69.00
![NEW Aquarius+ Mini 8Bit Retro Computer System - Assembled PCB ONLY picture](/store/img/g/z1EAAOSw20tl-IEg/s-l225/NEW-Aquarius-Mini-8Bit-Retro-Computer-System-Assem.jpg)
NEW Aquarius+ Mini 8Bit Retro Computer System - Assembled PCB ONLY
$89.00
![TRS80 Color Computer 1/2/3 Dragon 32/64 Atari Joystick Adapter picture](/store/img/g/Ky8AAOSwpYJhk~Lo/s-l225/TRS80-Color-Computer-1-2-3-Dragon-32-64-Atari-Joys.jpg)
TRS80 Color Computer 1/2/3 Dragon 32/64 Atari Joystick Adapter
$25.49
![Apple 661-0287 5.25](/store/img/g/4cYAAOSwz9hlQ79Z/s-l225/Apple-661-0287-5-25-Unidisk-Analog-CD-Card-Vintage.jpg)
Apple 661-0287 5.25" Unidisk Analog CD Card Vintage 1986 820-0190-A
$154.00
![GTMEDIA A6 Bluetooth 5.1 Transmitter Receiver Cordless Bass HiFi Audio Adapter picture](/store/img/g/fUUAAOSw~7ploONi/s-l225/GTMEDIA-A6-Bluetooth-5-1-Transmitter-Receiver-Cord.jpg)
GTMEDIA A6 Bluetooth 5.1 Transmitter Receiver Cordless Bass HiFi Audio Adapter
$49.99