I want to install and get to building a personal MySQL DB
So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file?
I've only had brief experience with MSAccess and OOo Base a long time ago, so details are appreciated, I just want to get up and running.
I have Ubuntu 10.10, 64 bit, if that affects much. If you can link me to a howto that does exactly what I'm looking for, that would work.
mysql database
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
migrated from superuser.com Mar 16 '11 at 23:00
This question came from our site for computer enthusiasts and power users.
add a comment |
So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file?
I've only had brief experience with MSAccess and OOo Base a long time ago, so details are appreciated, I just want to get up and running.
I have Ubuntu 10.10, 64 bit, if that affects much. If you can link me to a howto that does exactly what I'm looking for, that would work.
mysql database
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
migrated from superuser.com Mar 16 '11 at 23:00
This question came from our site for computer enthusiasts and power users.
add a comment |
So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file?
I've only had brief experience with MSAccess and OOo Base a long time ago, so details are appreciated, I just want to get up and running.
I have Ubuntu 10.10, 64 bit, if that affects much. If you can link me to a howto that does exactly what I'm looking for, that would work.
mysql database
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file?
I've only had brief experience with MSAccess and OOo Base a long time ago, so details are appreciated, I just want to get up and running.
I have Ubuntu 10.10, 64 bit, if that affects much. If you can link me to a howto that does exactly what I'm looking for, that would work.
mysql database
mysql database
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
edited Jan 5 at 2:51
Aaron Hall
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
asked Dec 14 '10 at 1:50
Aaron HallAaron Hall
6221621
6221621
migrated from superuser.com Mar 16 '11 at 23:00
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Mar 16 '11 at 23:00
This question came from our site for computer enthusiasts and power users.
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Ideally, you should have some level of experience in SQL coding if you want to hand code. This means you first get mysql-server (click-to-install)
For the most basic sql commands, you would need to install mysql-client as well. After that open a terminal and run mysql -u username -p for running mysql cli. Take a look at mysql documentation for learning mysql.
According to the open-office wiki, Openoffice Base is also integratable with mysql. Take a look here for more instructions. There are other mysql-gui tools available for ubuntu, the most recommended being Squirrelsql. For the export part to csv, I believe Openoffice should be capable of that (I have no experience of using Base)
In case you would like a web based interface, I would recommend phpmyadmin and sqlbuddy as two possible options. They can connect to external servers as well. So you can run them on other machines as well
edited May 23 '17 at 12:39
Community♦
1
answered May 18 '11 at 22:49
NemoNemo
6,60654062
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
add a comment |
I found installing as a complete package from http://www.apachefriends.org/en/xampp-linux.html#374 save LOTS of headaches. This will set up apache, mysql, and php.
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
add a comment |
(1) sudo apt-get install mysql-server in the terminal. That should set it up. It'll give you various prompts for the setup process.
(2) If you need to be able to access this from a different system (and not from the machine you install it on), do this. After the config, go find /etc/mysql/my.cnf. Locate any line saying skip-networking. Modify the line to say #skip-networking. if you do this step, make sure you do sudo service mysql restart in terminal before continuing!
(3) You will need experience with SQL code to be able to use the system, but all the information you need can be found on the mysql site: http://dev.mysql.com/doc/
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f30702%2fi-want-to-install-and-get-to-building-a-personal-mysql-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Ideally, you should have some level of experience in SQL coding if you want to hand code. This means you first get mysql-server (click-to-install)
For the most basic sql commands, you would need to install mysql-client as well. After that open a terminal and run mysql -u username -p for running mysql cli. Take a look at mysql documentation for learning mysql.
According to the open-office wiki, Openoffice Base is also integratable with mysql. Take a look here for more instructions. There are other mysql-gui tools available for ubuntu, the most recommended being Squirrelsql. For the export part to csv, I believe Openoffice should be capable of that (I have no experience of using Base)
In case you would like a web based interface, I would recommend phpmyadmin and sqlbuddy as two possible options. They can connect to external servers as well. So you can run them on other machines as well
edited May 23 '17 at 12:39
Community♦
1
answered May 18 '11 at 22:49
NemoNemo
6,60654062
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
add a comment |
Ideally, you should have some level of experience in SQL coding if you want to hand code. This means you first get mysql-server (click-to-install)
For the most basic sql commands, you would need to install mysql-client as well. After that open a terminal and run mysql -u username -p for running mysql cli. Take a look at mysql documentation for learning mysql.
According to the open-office wiki, Openoffice Base is also integratable with mysql. Take a look here for more instructions. There are other mysql-gui tools available for ubuntu, the most recommended being Squirrelsql. For the export part to csv, I believe Openoffice should be capable of that (I have no experience of using Base)
In case you would like a web based interface, I would recommend phpmyadmin and sqlbuddy as two possible options. They can connect to external servers as well. So you can run them on other machines as well
edited May 23 '17 at 12:39
Community♦
1
answered May 18 '11 at 22:49
NemoNemo
6,60654062
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
add a comment |
Ideally, you should have some level of experience in SQL coding if you want to hand code. This means you first get mysql-server (click-to-install)
For the most basic sql commands, you would need to install mysql-client as well. After that open a terminal and run mysql -u username -p for running mysql cli. Take a look at mysql documentation for learning mysql.
According to the open-office wiki, Openoffice Base is also integratable with mysql. Take a look here for more instructions. There are other mysql-gui tools available for ubuntu, the most recommended being Squirrelsql. For the export part to csv, I believe Openoffice should be capable of that (I have no experience of using Base)
In case you would like a web based interface, I would recommend phpmyadmin and sqlbuddy as two possible options. They can connect to external servers as well. So you can run them on other machines as well
edited May 23 '17 at 12:39
Community♦
1
answered May 18 '11 at 22:49
NemoNemo
6,60654062
Ideally, you should have some level of experience in SQL coding if you want to hand code. This means you first get mysql-server (click-to-install)
For the most basic sql commands, you would need to install mysql-client as well. After that open a terminal and run mysql -u username -p for running mysql cli. Take a look at mysql documentation for learning mysql.
According to the open-office wiki, Openoffice Base is also integratable with mysql. Take a look here for more instructions. There are other mysql-gui tools available for ubuntu, the most recommended being Squirrelsql. For the export part to csv, I believe Openoffice should be capable of that (I have no experience of using Base)
In case you would like a web based interface, I would recommend phpmyadmin and sqlbuddy as two possible options. They can connect to external servers as well. So you can run them on other machines as well
edited May 23 '17 at 12:39
Community♦
1
answered May 18 '11 at 22:49
NemoNemo
6,60654062
edited May 23 '17 at 12:39
Community♦
1
edited May 23 '17 at 12:39
Community♦
1
edited May 23 '17 at 12:39
Community♦
1
1
answered May 18 '11 at 22:49
NemoNemo
6,60654062
answered May 18 '11 at 22:49
NemoNemo
6,60654062
answered May 18 '11 at 22:49
NemoNemo
6,60654062
6,60654062
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
add a comment |
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
Took the words right out of my mouth Capt. Nemo. Great suggestions. +1 on learning the CLI.. GUI tools are good for discovering options at the beginning, but there's nothing like learning SQL to get the full power of relational dbs.
– SpamapS
May 19 '11 at 1:08
add a comment |
I found installing as a complete package from http://www.apachefriends.org/en/xampp-linux.html#374 save LOTS of headaches. This will set up apache, mysql, and php.
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
add a comment |
I found installing as a complete package from http://www.apachefriends.org/en/xampp-linux.html#374 save LOTS of headaches. This will set up apache, mysql, and php.
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
add a comment |
I found installing as a complete package from http://www.apachefriends.org/en/xampp-linux.html#374 save LOTS of headaches. This will set up apache, mysql, and php.
I found installing as a complete package from http://www.apachefriends.org/en/xampp-linux.html#374 save LOTS of headaches. This will set up apache, mysql, and php.
answered Dec 18 '10 at 19:34
Ray
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
add a comment |
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I wasn't asking about setting up a LAMP stack, I'm not there yet, and how do I know I can trust the site you linked to? For all I know, it could have a trojan.
– Ari Hall
Dec 19 '10 at 17:39
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
I recommend against using XAMPP on Ubuntu. If you need a LAMP stack, there's a metapackage for that. On the other hand, if you have LAMP you can use phpmyadmin, which greatly simplifies MySQL administration. Also, I can vouch for apachefriends.org. XAMPP is not a trojan, just something you don't need.
– koanhead
May 18 '11 at 23:00
add a comment |
(1) sudo apt-get install mysql-server in the terminal. That should set it up. It'll give you various prompts for the setup process.
(2) If you need to be able to access this from a different system (and not from the machine you install it on), do this. After the config, go find /etc/mysql/my.cnf. Locate any line saying skip-networking. Modify the line to say #skip-networking. if you do this step, make sure you do sudo service mysql restart in terminal before continuing!
(3) You will need experience with SQL code to be able to use the system, but all the information you need can be found on the mysql site: http://dev.mysql.com/doc/
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
add a comment |
(1) sudo apt-get install mysql-server in the terminal. That should set it up. It'll give you various prompts for the setup process.
(2) If you need to be able to access this from a different system (and not from the machine you install it on), do this. After the config, go find /etc/mysql/my.cnf. Locate any line saying skip-networking. Modify the line to say #skip-networking. if you do this step, make sure you do sudo service mysql restart in terminal before continuing!
(3) You will need experience with SQL code to be able to use the system, but all the information you need can be found on the mysql site: http://dev.mysql.com/doc/
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
add a comment |
(1) sudo apt-get install mysql-server in the terminal. That should set it up. It'll give you various prompts for the setup process.
(2) If you need to be able to access this from a different system (and not from the machine you install it on), do this. After the config, go find /etc/mysql/my.cnf. Locate any line saying skip-networking. Modify the line to say #skip-networking. if you do this step, make sure you do sudo service mysql restart in terminal before continuing!
(3) You will need experience with SQL code to be able to use the system, but all the information you need can be found on the mysql site: http://dev.mysql.com/doc/
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
(1) sudo apt-get install mysql-server in the terminal. That should set it up. It'll give you various prompts for the setup process.
(2) If you need to be able to access this from a different system (and not from the machine you install it on), do this. After the config, go find /etc/mysql/my.cnf. Locate any line saying skip-networking. Modify the line to say #skip-networking. if you do this step, make sure you do sudo service mysql restart in terminal before continuing!
(3) You will need experience with SQL code to be able to use the system, but all the information you need can be found on the mysql site: http://dev.mysql.com/doc/
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
edited Mar 17 '11 at 0:19
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
answered Mar 16 '11 at 23:10
Thomas Ward♦Thomas Ward
43.9k23121174
43.9k23121174
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f30702%2fi-want-to-install-and-get-to-building-a-personal-mysql-db%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
