General :: 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
ADVERTISEMENT
CentOS 5 :: Phpmyadmin Unable To Create A New User In Mysql Database
May 13, 2010I 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)"
General :: Restore 200+ Mysql Database With Shell Script?
Jul 22, 2011I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies View RelatedGeneral :: Mysql Error Can't Create Database 'test' When Configure?
Feb 8, 2010mysql -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.....
General :: How To Change Default Database For One User In MySQL
Sep 12, 2011Though this might seem like a [URL] question at first glance I don't think it is. I have a mysql database on a server at work. Every time I log in to execute a query, I have to manually select the one database I want from the one database I have, which is a waste of time. Is there any way for me as an end user to set a default?
View 2 Replies View RelatedNetworking :: Database Error: Unable To Connect To Database:The MySQL Adapter "mysql" Is Not Available
Jun 16, 2011I'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]...
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 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.
Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket
Aug 25, 2010I'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:
Slackware :: Postfix - Cyrus SASL Authentication - Pam-mysql - Mysql Database
May 10, 2011Pam-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 --
Server :: Change The Owner Of The Mysql Database With Shell Commands?
Jun 19, 2010i want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View RelatedFedora Installation :: Database Conversion From Mysql 4.1.22 To Mysql 5 For A Client?
Apr 2, 2009I 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 RelatedOpenSUSE :: 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?
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 RelatedGeneral :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)
Jun 2, 2010i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
Server :: Does The Mysql User Need Bash Shell
Oct 2, 2010Is there any reason for the mysql user to need bash shell?
From /etc/passwd:
Code:
mysql:x:100:103:MySQL server:/var/lib/mysql:/bin/bash
Will anything break if I change that to /bin/false?
OpenSUSE Network :: ERROR 1044 (42000): Access Denied For User ''@'localhost' To Database 'mysql'
Nov 9, 2010I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?
Aug 2, 2010I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
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 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?
General :: Mysql Best SQL Database Gui Tool
Mar 25, 2010Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies View RelatedGeneral :: MySql Database From Usb Stick
Jul 30, 2011I recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.
General :: Database Application Using MYSQL
Mar 24, 2010I posted a thread regarding a CD Base Application. I can run the program, but for some reason It does not seem to work properly.
For some reason in exits the program back to the command prompt. I am using the code from Linux programming 4th edition which you can get it from here...and in the folder ch08/app you will find all you need to create the CD database application.
General :: Commands For Mysql Database
Nov 26, 2010I am not having any knowledge of mysql database & in my present jobs i have to solve problem on mysql database. need some commands which are used regularily in database.
View 1 Replies View RelatedGeneral :: Copy Mysql Database
Mar 8, 2010I want to migrate a mysql databases from a old server to a new server ( Redhat ) , can advise what I need to do ,is it just copy all .frm , .MYI & .MYD files to new server will do ? or I need to do export and inport data ?
View 12 Replies View RelatedGeneral :: Backup A Particular Database In MYSQL?
Jun 27, 2011How to backup a particular Databases..through Bash script! For example i have 6 databases;
Anish
linux
Software
Questions
Rhce
Google
these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
General :: Update Mysql Database From 5.0 For 5.1?
Sep 5, 2010i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
View 2 Replies View Related