General :: Non-Root Portable Install Of MySQL Server?
Mar 3, 2010Is there a non-root, portable distribution of MySQL for Linux? I need to do some testing on a server that I do not have root access to.
View 2 Replies
ADVERTISEMENT
General :: Interact With The Mysql To Reset The Root Mysql Pass?
Jun 14, 2011I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
General :: 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 :: Mysql-server Root Connects, No Other Account Does?
Jul 17, 2011I'm running Debian Testing and am confounded by a new problem.mysql -u root -p works great.mysql -u mythtv -p doesn't. This is a first for me.I did the usual as mysql root: mysql> create user 'mythtv'@'127.0.0.1' identified by 'mythtv';Query OK, 0 rows affected (0.01 sec)
mysql> grant all on *.* to 'mythtv'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
[code]....
Server :: How To Reset Root Password Of MySQL?
Sep 21, 2010for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.
View 13 Replies View RelatedServer :: MySQL - Remote Access For Root?
Aug 9, 2010I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
View 3 Replies View RelatedServer :: MySQL Root User - Administration And Permissions
Jun 22, 2010I'm using an older redhat system (2.6.9-22.ELsmp) here which is running an older mysql (server version: 4.1.12). I don't think that's the source of the problems. I believe that have understood things rightly when I say that the mysql root user is unrelated to the linux root user ... in my case I believe the root user to be the unix user mysql. So when I connect to the server (local host from a local terminal) I use:
Code:
-bash-3.00$ mysql -u mysql -p
and enter a blank password
This gets me on, however I seem unable to do anything like create database or alter privilege. I wonder if its related to my finding no database called mysql?
-bash-3.00$ mysql -u mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11 to server version: 4.1.12
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)
Although I understand that show databases will not show things I have no priv to see. Does this mean my settings for the users are all screwed? How do I rectify this situation? Some other (perhaps) useful information.
Code:
[root ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
So my BASEDIR seems to be nothing like is suggested in the documentation at [URL].
Software :: Cannot Access MySQL Server Other Than User=root?
Apr 13, 2011I've tried every manual there is for creating new MySQL users ... but without success.
I keep getting
Code:
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES) even though I just created it with all privileges ... WITH a password that I DO remember .
Fortunately I still have access via the MySQL root user (so I try not to disturb that user, because I have had computers with THAT account not accessible as well - even WITH resetting the password via skip-grant-tables).
General :: Install MySQL Server On Debian While Offline?
Aug 29, 2011I'm a Linux newbie. I want to install mysql-5.5.15-linux2.6-x86_64.tar.gz on a Debian box offline without using the apt command. How can I do this?
View 1 Replies View RelatedFedora Installation :: Change The Root Password Of MYSQL Server
Mar 16, 2009How can I change the root password of MYSQL server. I have just finished installation, but I mistakenly typed the wrong root password, and now I need to change it from command line, because I cannot even access the UI.
View 8 Replies View RelatedServer :: Changed Root User Access For MySQL To Any From Localhost?
Mar 14, 2011I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?
View 2 Replies View RelatedUbuntu :: Install Mysql Without Setting Root Password
Dec 28, 2010Is there any way i could install mysql without setting the password for the root account during installation? preferably using the command line.
View 4 Replies View RelatedOpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock
Jun 7, 2011I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
General :: Backing Up /var/lib/mysql As Non-root User?
Jan 4, 2011I am using Ubuntu 10.04.1 LTS x64. I would like to backup my /var/lib/mysql directory as a non-root user.
I have been backing this up using cron as the root user, but another admin in my company insists that we create a separate user to perform this task for security reasons. I have created a user, created a group, added the user to the group, but still cannot access /var/lib/mysql/mysql directory as that user. I would like that user to have +rx access only.
Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'
Mar 26, 2010I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
General :: Error - [root]# Yum Install Xorg-x11-server-Xvfb
Jun 3, 2011I am using RHN system. Today, I were running Yum, some errors appeared as the below. Before, I had never such problems. I tried to search some solutions in Google, but can not find it.
[root]# Yum install xorg-x11-server-Xvfb
or
[root]# Yum list updates
There was an error communicating with RHN RHN support will be disabled Error communicating with server. The message was: Connection timed out
Red Hat / Fedora :: Trying To Install Mysql-server ?
Feb 23, 2010I am trying to install mysql-server using the command
But get the following error:
Server :: Can Not Install Php-mysql / Resolve This?
Jul 9, 2011I have just updated PHP from 5.1.6 to 5.3.6
on CentOS 5.6, After reboot I have tried to install php-mysql
but I got error says code...
Software :: Install CentOS On One Of Those BSI Portable Boxes?
Jul 6, 2010I'm trying to install CentOS on one of those BSI portable boxes. When installing, it gives this error:"Errno 30 Read-only file system." Which is weird because it's obviously not read only, and doesn't fail right away. It's an IDE optical drive, and a SATA hard drive. I thought it was the SATA optical drive to IDE HDD install issue that has been seen before, but not the case here. The disc is in known-working condition.
View 1 Replies View RelatedDebian Installation :: Install SSH On Server But Not For MySQL
Sep 1, 2014I would like to enable SSH on my debian server but not for MySQL. For MySQL, I want to connect normally.
View 7 Replies View RelatedFedora :: Sudo Apt-get Install Mysql-server ?
Jan 16, 2011What is sudo? I tried to do this : sudo apt-get install mysql-server
And then it gave me this :
We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:
1) Respect the privacy of others.
2) Think before you type.
3) With great power comes great responsibility.
[sudo] password for mlocicero: mlocicero is not in the sudoers file. This incident will be reported.
Ubuntu :: Mysql Server Install Error
May 15, 2011I'm trying to install the squeezebox server software in Ubuntu 9.10 and I'm getting an error when it tries to install mysql-server. Seems like people have run into this before [URL]... but so far, I can't find a solution.
[code]...
Ubuntu Servers :: Can't Install Mysql-server
Jun 3, 2011i'm trying to install mysql-server on my pc. so i type this on my terminal:
Code:
sudo apt-get install mysql-server
it starts to download & install everything, but when it has to configure the server, it simply "freeze" and does nothing!
how can i solve that? i've tried to purge and reinstall, but it was no use!
Server :: MySQL Datadir From Previous Install?
Jun 22, 2010I was running Ubuntu 9.10 and had the MySQL datadir moved to a different directory, /store/mysql. Due to a filesystem problem on the upgrade to Ubuntu 10.04, I was forced to reinstall. My /store/mysql was copied back over, changes to /etc/mysql/my.cnf and /etc/apparmor.d/usr.sbin.mysqld, but MySQL hangs when I go to start it and nothing is showing up in any of the logs. How do I get MySQL to recognize the datadir from the previous install?
View 1 Replies View RelatedSoftware :: Install Mysql-server Into A Pendrive ?
Nov 16, 2010I need to install mysql-server into a pendrive because i want to use a database into the pendrive..
I'm using debian, and i tried to put the var/lib/mysql directory into the pendrive, then i modified the my.cnf file with this string:
But now when i write "mysql -u root -p" i receice this error:
I think because i have to install mysql into the pendrive, isn't it?
CentOS 5 :: Mysql-server Fails To Install?
Feb 7, 2011Im having a major problem with mysql-server failing to install.The installation stoppes on "Running Transactions" (have tried waiting for 10 minutes). When I use Ctrl+C an error appears:error: %pre(mysql-server-5.0.77-4.el5_5.4.x86_64) scriptlet failed, signal 2 error: install: %pre scriptlet failed (2), skipping mysql-server-5.0.77-4.el5_5.4
View 2 Replies View RelatedGeneral :: Access Remote Mysql Server Through Socks Proxy Server?
Aug 25, 2010Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
View 1 Replies View RelatedUbuntu :: Unable To Install Mysql-server On Lucid?
May 11, 2010I've tried installing mysql-server on Lucid, and I get errors that it cannot set the root password. A screenshot is attached.
I have no idea what to do. I've tried purging configuring and reinstalling. Same problem. I can't find anything in the logs.
Ubuntu :: Cannot Install Mysql, Php5 And Apache2 Server On 10.04?
Aug 4, 2010currently I am using Ubuntu 10.04.I want to install mysql, php5 and apache2 server in my machine. I have tried this- aptitude install mysql-server mysql-client
But the outcome is
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
[Code]...
CentOS 5 Server :: Apache MySQL PHP Does Not Work On New Install
Jul 17, 2010I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...