Software :: Create Mysql Database From Command Line?
Feb 13, 2010
I 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)?
View 3 Replies
ADVERTISEMENT
Aug 7, 2010
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies
View Related
Jul 28, 2009
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
View 4 Replies
View Related
Aug 11, 2011
i'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?
View 5 Replies
View Related
Aug 12, 2010
After 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
Feb 8, 2010
mysql -u root -p but unable to create any database.
if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)
my location for database is /var/lib/mysql and permissions are
drwxrwxrwx mysql root.....
View 1 Replies
View Related
May 13, 2010
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
View 2 Replies
View Related
Jan 16, 2011
I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
View 6 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
Aug 17, 2011
My computer has broken and I cannot login. I don't know what caused it.
I am using Fedora 14 and so it is easy to retrieve my files with the Fedora 14 installation disk under the 'restore' option. I cannot however, work out how to retrieve my MySQL data.
Would anyone be able to shed some light on this matter?
View 1 Replies
View Related
Mar 5, 2011
I am using ubuntu and mysql.I have a list of many .sql files, like 1.sql, 2.sql, 3.sql ... 100000.sqlI need to insert them into the database mysql mydb < *.sqlGives me: -bash: *.sql: ambiguous redirect
View 2 Replies
View Related
Jun 17, 2010
I 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.
View 1 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
May 10, 2011
Pam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
View 3 Replies
View Related
Apr 2, 2009
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies
View Related
Feb 7, 2010
I am implementing a strategy to organize my data among the several machines I work with and thought that getting some ISO images out of it could be a good idea because that way data would be 'read only' thus allowing for easier synchronization.
At first I thought of using the "dd" command to create the ISO out of a directory, but it fails code...
So, I have two questions:
Is the ISO 'format' capable of storing complex directory structures with long filenames (pretty much as any Linux filesystem does), or are there some inherent limitations?
Supposing the ISO format is not constrained, which command would allow me to create an ISO file out of a directory?
View 5 Replies
View Related
Aug 22, 2011
I'm developing in java.
I want to create a GUI interface for some command line commands (drush - drupal).
How can I interact with the command line commands with java? or any other languege?
View 6 Replies
View Related
Sep 4, 2010
How can I create multipart rar file in Linux using the official console rar client?RAR 3.90 Copyright (c) 1993-2009 Alexander Roshal 16 Aug 2009Shareware version Type RAR -? for helpI want a multipart rar with each part size being 150 MB.
View 1 Replies
View Related
Oct 13, 2010
How to split a tar file into smaller parts at file boundaries?
How can I create a multipart tar file in Linux?
View 2 Replies
View Related
Sep 20, 2010
Is there a way to create a windowed message from the command line? Like an alert?
View 3 Replies
View Related
Dec 16, 2009
i have a server running on centos5, i have run vsftp and samba, and i need create a user through command line and set your default directory, i can do this through graphic interface, but i need do throug line command.
View 12 Replies
View Related
May 18, 2011
I use putty to get to my RHEL 5.3 workstation from my Windows laptop.
Typically, if I want a new terminal on my windows 7 workstation from another terminal or mc, I have to type start and I will see a new terminal window running the default shell.
QUESTION : What is the equivalent command in RHEL 5.3 (and or solaris) to create a new terminal window from the command line ? I will be entering this command from the shell prompt or mc's command line.
In Windows, if I want to start another terminal and in that terminal, I want to run a program, I can do "start program.exe arg1 arg2". this will create a new terminal window and runs program.exe in that terminal window. I don't have to create a terminal and then in a separate step run the program. How can I do this in Linux ?
View 3 Replies
View Related
Feb 21, 2010
I use a few command line programs quite often such as nano and mpc. I'd like to create a shortcut icon to open them rather than opening a terminal and then typing in the program name to open it. For example, how could i open konsole with nano opened in one step?
View 5 Replies
View Related
May 18, 2011
How can I create a multipart 7zip file in Linux using the p7zip console client? My console app is
7-Zip [64] 9.13 beta Copyright (c) 1999-2010 Igor Pavlov 2010-04-15
p7zip Version 9.13 (locale=C,Utf16=off,HugeFiles=on,4 CPUs)
View 1 Replies
View Related
May 8, 2010
I can do:mkdir messages and then: touch messages/hello.txt Is there a command that will do both - create the directory if it doesn't exist, and then the empty file? Something like: touch -p messages/hello.txt
View 1 Replies
View Related
Sep 4, 2010
How can I create a multipart 7zip file in Linux using the p7zip console client?
Many people referred me to it. My console app is
7-Zip [64] 9.13 beta Copyright (c) 1999-2010 Igor Pavlov 2010-04-15
p7zip Version 9.13 (locale=C,Utf16=off,HugeFiles=on,4 CPUs)
View 1 Replies
View Related
Oct 6, 2010
I am currently interning at a place and my job is to essentially learn UNIX. My supervisor gives me problems here and there to help guide me with my learning but for the most part I'm doing this all by self-teaching myself. Needless to say I have run into a few obstacles...for instance-Create a *one* line command that, using tar, will collect the full /usr/local directory (you need to run this as root again) and copy the whole /usr/local structure under /optFor example /usr/local/bin/hello will become /opt/local/bin/hello, etc. I want this as follows:1. /usr/local is collected by tar, but the output of this tar command is its stdout.. what you get from the previous stdout, you compress with gzip and send it to stdout again 3. get this output and decompress with gzip.. get this output and pipe to tar in a way that will extract the tree under /opt.If anyone knows how I could go about doing this, please let me know, or at the very least point me in the right direction. What I've got so far (which could be completely wrong) is:tar cvf - usr/local/ | gzip -c - | gunzip -c - | tar xvf -in theory I feel like this should work (except for extracting the tree under /opt...i'm kinda stuck there)
View 3 Replies
View Related
Nov 3, 2009
I work with a Debian Squeeze on my laptop and I have a 160GB external hard disk. My hard disk was formatted FAT32, but I decided to format it using ext2. I formatted it using fdisk from command line and everything went well. Unfortunately, when I mount my hard drive(which is auto-mounted from Debian) it has got root both as owner and group. Then I can't write to it because I have no permission to do that. Is there a setting to create an ext2 partition which has as owner the logged system user in order to have right permission every time.
View 7 Replies
View Related
Dec 9, 2010
I'm having problems with bash quoting. Maybe someone can tell me what's going on.. Basically, I need to create a command line inside a bash script that contains arguments that contain spaces and bash variables that need to be expanded.
[Code]...
View 5 Replies
View Related
Feb 27, 2011
I have a CentOS 5.5 server running currently with a Netgear gigabit ethernet card and for wifi I have a wi-fi card with the chipset: RT2860.Now I have gotten the ethernet card and wi-fi card working but my main question is: How do you bridge the connection between the ethernet card and the wi-fi card to create a wireless network with a hidden ESSID if possible and WPA encryption? (So the server basically acts as a wireless router as well as doing all the other stuff I need to do on it).
View 2 Replies
View Related