Ubuntu Servers :: Create More Than One Mysql Instance?
Dec 28, 2010Hi. I need to create second mysql instance on the same server but another port. What is the right way to do that?
View 1 Replies
ADVERTISEMENT
Ubuntu Servers :: [MySQL] Where To Create A New Table
Jul 13, 2011I've started a webserver at 127.0.0.1:**** I want to be able to use a database for this server. Which schema do I use to add a new table to? Do I create a new Schema altogether?
View 5 Replies View RelatedSoftware :: How To Stop Mysql Instance
Aug 4, 2011here is contents of .my.cnf :
[mysql]
host=localhost
user=root
password=mei
[Code].....
why mysql client can login after mysql instance has been shutdown? there is only one mysql instacne running on my computer.
Programming :: Python - Using Input To Create New Instance Of A Class?
Apr 6, 2011The intent here takes a little background info.I'm trying to make a basic inventory control to reinforce my studies. It will have a while loop that displays amenu for add, edit, view, and quit. Lets assume the following:
Code:
class inventoryItem:
itsDescriptiveName = None
[code]....
OpenSUSE Install :: Create A Instance On A Windows 7 PC And Use Dual-boot?
Nov 23, 2010I'm trying to create a Linux instance on a Windows 7 PC and use dual-boot. I have created 64GB of space for Linux. Is this enough? When I boot from the live DVD and go through the setup, I get stuck setting up the unassigned space as a linux partition. I don't understand what the setup is trying to tell me and I'm afraid I'll wipe out Windows 7. The message I get says there isn't enough space even though the unassigned available area is 64GB. I am very timid about following what Yast2 is telling me because to my untrained eye it appears the setup wants to use my entire hard drive. Where can I find more information about the disk setup section of the installation process?
View 9 Replies View RelatedGeneral :: Create A New Mysql User And A Mysql Database At The Shell Prompt?
Aug 7, 2010How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedUbuntu :: Links From Widgets - Task Bar Shows An Instance Of Konqueror And Another Instance Of Firefox
Feb 15, 2010I have KDE 4.4 and Firefox 3.6. Whenever I click a link from a plasmoid widget, it tries to open Konqueror and another instance of Firefox. The page actually loads in the opened Firefox window, but the task bar shows an instance of Konqueror and another instance of Firefox, that keeps loading for a while then close. See image below:
I currently have setup the browser default application as "firefox". If I set this option to use the default application, it opens in Konqueror and I don't see additional windows in the task bar. If I change the option to "firefox %u", then it exhibit the same issue, but the process is much faster, so the loading windows don't stay for long in the task bar. Additionally, it opens the link on a new Firefox window and opens the page twice. Although Konqueror is not loaded, the bouncing icon next to the mouse pointer shows up and stay for a while.
Ubuntu Servers :: Can't SSH Into UEC VM Instance
Feb 10, 2010I am running Ubuntu Enterprise Cloud on two PCs, one as Controller, one as a node. I have downloaded two Ubuntu virtual machine images from the Ubuntu Enterprise Cloud Store and can successfully start instances of them with: euca-run-instances -k mykey emi-XXXXXXXX -t c1.medium
If I run this command I can see the instance is running: watch -n5 euca-describe-instances
I can ping the IP address of the VM instance from my Controller but I can't make an SSH connection to it. I'm following the instructions @ [URL] so I have tried connecting with: ssh -i ~/.euca/mykey.priv ubuntu@192.168.1.250
The result is: Permission denied (publickey).
If I try adding -v to the ssh command I get:
OpenSSH_5.1p1 Debian-6ubuntu2, OpenSSL 0.9.8g 19 Oct 2007
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: Applying options for *
[code]....
Ubuntu Servers :: Setting Up Ec2 Instance Of 10.04?
Mar 24, 2011I need to set up an ubuntu 10.04 instance on ec2, but there are some instance ready available I tried with few but I am not really happy with that since those are meant for test puporse.
I have to deploy a java/j2ee based web app with mysql. 1)need to install tomcat 2)java runtime 6 3) apache web server
What would be the best image to use for my requirement and I initially planning to launch with the micro instance if my web app demands I may further move to small and larger instances. So it should be eligible for free usuage tier.
Ubuntu Servers :: Multiple Instance Of Postgres On The Same Machine?
Mar 16, 2010how to setup multiple instance of postgre server on the same machine.
View 4 Replies View RelatedUbuntu Servers :: UEC: Unable To Ping And Connect To Instance?
Mar 30, 2010I have set up UEC on a single machine 64 bit blade. I have followed the steps as per the documentation.I am using Managed NOVlan mode. I have installed the Karmic kola image. When I try to run the instance, I get an error "no resources available. Try --addressing private". When I try addressing private, an ip address 172.19.1.2 is assigned and the instance was running.
a) When trying to ping the ip, error displayed that the host is unreachableb) I am also unable to connect to ubuntu@172.19.1.2 using ssh. Error message is displayed that " No route to host".I have searched the forums but couldnt find any solutionPS: I suppose everyone is very busy. I see very limited responses to posts. Sharing your experience and expertise will be helpful for all and will reiterate the meaning of ubuntu
Ubuntu Servers :: Unable To Access UEC Instance From Public Ip?
Apr 14, 2010I have setrup Ubuntu Enterprise Cloud on a single machine.
1) I am able to run the instances from store (karmic) On running the instance two ips are assigned (public and private) as 10.B.C.X and 172.19.1.2
2) I am able to connect to the instance (10.B.C.X) through ssh (using key)
3) However I am unable to access the instance outside the UEC (using public ip). When I try pinging, I get an error Request timed out or sometimes Destination host unreachable.
4) I have provided the following access using euca-authorize
Details below:
1) Hardware : Blade (64 bit)
2) Version : Ubuntu 9.10; Eucalyptus the one using apt-get install eucalyptus
3) Topology : Single physical system
4) Mode : Managed no-vlan
[Code]...
Ubuntu Servers :: UEC 10.04 - Unable To Conect To Instance - Network?
Nov 8, 2010I had installed UEC 10.04. It is a 2 server configuration with CC, CLC, SC and Walrus on one server and NC on another server. I could run instance of images, But when i try to ssh to the instance, it doesn't work.
It shows ssh: connect to host xxx.xxx.xxx.xxx port 22: No route to host. This to me seems there is a problem with my network connection. Pl find below the ifconfig output of the two servers:
Controller:
eth0 Link encap:Ethernet HWaddr 00:0c:29:90:95:17
inet addr:172.18.144.36 Bcast:172.18.145.255 Mask:255.255.254.0
inet6 addr: fe80::20c:29ff:fe90:9517/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
[Code]...
Ubuntu Servers :: Tomcat Manager And Webmin Not Accessable On EC2 Instance
Jun 23, 2010I've got my first EC2/cloud instance of Ubuntu up and running. This is my first time really dealing with the server edition. I've loaded Apache, Tomcat, PostgreSQL, and Webmin. I've got a public IP on the instance and it is working. I've opened, for now, ports 80, 8080, 443, and 10000 to 0.0.0.0/0.
I cannot get into Tomcat Manager or Webmin at all through a browser. For Tomcat, I've restarted, stop/started, and verified that Tomcat is running. I installed Webmin all through apt-get commands so any dependencies should have been installed (first time doing it this way), but cannot get to the login screen. But if I just go to the IP, Apache goes to the "It Works." splash page. Did I miss some set up? Is there an internal firewall in Ubuntu Server edition that needs to be set?
Ubuntu Servers :: Installed Vsftpd - Restart: Unknown Instance
Nov 23, 2010I have installed vsftpd. When I run the command sudo service vsftpd restart, I get the following response: restart: Unknown instance. But if I run the command sudo service vsftpd start, I get the following response: vsftpd start/running, process 3804. To understand what is happening, I run the command ps aux | grep vsftpd, I get root 3805 0.0 0.0 27120 620 ? Ss 14:00 0:00 usr/sbin/vsftpd.
View 3 Replies View RelatedGeneral :: Administer Each Of The Servers From One SWAT Instance?
Sep 16, 2010I have a few different Linux servers with samba shares on each of them. Is it possible to administer each of the servers from one SWAT instance?
View 1 Replies View RelatedUbuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?
Jun 17, 2010I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?
Jan 14, 2011i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
Fedora Servers :: Mysql At Boot Time In 10 / Get Mysql To Start At Boot?
Jul 28, 2009I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
Server :: Mysql - Cannot Create Database
Jul 28, 2009I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
Ubuntu :: Create A Stored Procedure In 10.04 Mysql Error 1307
May 5, 2010recently upgraded, now none of my stored procedures work. All return error 1307. what can I do to prevent this from happening?
View 3 Replies View RelatedGeneral :: Create A Pptp Username Through Mysql?
May 19, 2011my vpn server has been working well. but all user accounts are stored in /etc/ppp/chap-secrets. the question is how to create a pptp username through mysql?
View 3 Replies View RelatedSoftware :: Mysql 5.0 - What Is The Use Of UNION=() In CREATE TABLE
Feb 24, 2009What is the use of UNION=() in CREATE TABLE?
Code:
ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 UNION=();
I have been given some code and could not explain why it's err's out. Checked the mysql 5.0 manual but nothing[URL]. It only explains using UNION in a SELECT statement which I understand. If I drop off UNION=() then CREATE TABLE works fine.
Programming :: Create A User For Php/MySQL Under Ms Win Environment?
Jun 30, 2010create a user for php/MySQL under ms win environment?
View 1 Replies View RelatedFedora Installation :: Mysql Fc14 Can't Create New User?
Nov 10, 2010I installed mysql on FC14, but can't successfully create a new user. It lets me go through all the steps without complaint, but then I can't log into mysql as the new user.
Here's what I did.
1) yum install mysql mysql-server
2) service mysqld start ##sets up mysql
3) mysqladmin -u root password myownsecrectpass ##create a root password
3b) mysql -uroot -p; #log in as root, this works fine
4) CREATE DATABASE webdb;
5) CREATE USER 'anewuser'@'%' IDENTIFIED BY 'password123'; ##create anewuser with a passwd
6) GRANT ALL ON webdb.* TO anewuser@'%';
7) FLUSH PRIVILEGES;
Then I log out of mysql as root and try to log in like this
mysql -uanewuser -p
I enter the password and get this error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
OpenSUSE :: Create A Database With The Mysql That Came With The Suse Installation?
Aug 11, 2011i'm trying to create a database with the mysql that came with the suse installation, my problem is that i can't get mysqladmin to work it spits out this: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! So I'm stuck at square one php info() seems ok with the installation and the installed client connects to my remote DB ok. I checked the server with ps -ef | grep mysqld and I get the following:
2438 2436 0 15:47 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/home/ben/.local/share/akonadi//mysql.conf --datadir=/home/ben/.local/share/akonadi/db_data/ --socket=/home/ben/.local/share/akonadi/socket-linux-ygk7.site/mysql.socket root 6248 6151 0 16:01 pts/0 00:00:00 grep mysqld
Which doesn't really mean a lot to me but looks ok, anyway my question boils down to does anyone have any obvious ideas of what I'm doing wrong or is, as others have hinted, suse's mysql installation is broken?
OpenSUSE Network :: MySQL Create User/permissions?
Jan 13, 2010MySQL gets installed with root user by default, root user can administer every mysql database installed in the system. Question is how to create a new user that will not be able to administer all the databases in the system the way as root user is? Can it be done using webmin?
View 7 Replies View RelatedServer :: Create A Virtual User System With Mysql?
May 27, 2011I'm using dovecot pop3 server in my website. I tried to create a virtual user system with mysql. But it didn't work. Next I tried to debug my work with reading of dovecot log. I enabled logging in it by changing this values in /etc/dovecot/conf.d/10-logging.conf:
Code:
log_path=/var/log/dov
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
After that I tried to login to the pop3 via telnet and it failed as usual. After I checked the log file (/var/log/dov), but it does not contain any information about that failed login. Only there was some information about starting up of dovecot! Does any body know that what is the problem and why dovecot doesn't log that?
Software :: Create Mysql Database From Command Line?
Feb 13, 2010I want to create database from script directly by taking inputs USER, PASSWORD and DBNAME.code...
How to resolve this or any alternate method (other than entering into mysql prompt like mysql -u USER -pPASSWORD)?
Software :: Opsview Unable To Create Database Using Mysql)?
Aug 12, 2010After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.but while running below command get an error,#mysqladmin -u root password {password}mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using pa
View 4 Replies View Related