I logged in phpmyadmin as root (with password that I just created in terminal), old databases are there but I have no privileges to create a new one.
View 1 RepliesIve done something, Im not sure what...... I was trying to backup my mysql DB so I can reformat that server and install different server OS, then reinstall mysql and restore the DB... Well, somewhere in this mess I did something and now I get DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'CONSTANTLY! I cant see any of my SQL DB's anymore... I just need to get the privileges back that Im missing, back up these DB's and get on with this already!
View 5 Replies View RelatedI 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)"
Unless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it. Well I am not familiar with it, so I wam wondering how to do it. As well when I run
mysql - p program </usr/share/program/mysql.sql>
It asks for a password. how do i find out this password.
I am running Ubuntu 9.10 with Apache, phpMyAdmin and MySQL. Normally phpMyAdmin loads properly, but the other day I created a large database of 6,000+ tables and 1.3 GB of data in the entire database. Now phpMyAdmin loads and shows my different databases, but if I try to open the new large database, it just loads a white page with no content. Does anyone know if I can reconfigure my server so it will be able to show parts of the database?
View 2 Replies View RelatedI want to create a user who has all the privileges that root user has.I know how to create a user but i don't know how to grant root privileges to him.
View 10 Replies View RelatedI create a user in CentOS 5.5 for using with my email account.
useradd ralf
passwd ralf
use "ralf user" only for my email account. How can I remove others privileges/permissions? Also, I want to use "ralf user" without root privileges/permissions.
i do need to create 1 user who has similar to root privileges but the username will not be root.
View 13 Replies View Relatedubuntu 9.10 64 biti try to install XAMPP and i want to create new database by use phpMyAdmin
at MySQL localhost create new database it show No Privileges how to create new database from terminal
I want to create a new LDAP database.
Part of the new configuration is
Code:
dn: olcDatabase={1}hdb,cn=config
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {1}hdb
[Code].....
Does anybody know if it is possible to hide certain databases from the root user in MySQL?
It may sound stupid, since the root is the root and all that, and it may feel strange but it kind of adds a level of abstraction which I want to give the "root user", and I want to avoid going down the route of creating a new mysql instance on the server.
I had wondered if there is some kind of 'hide' parameter for a database or whether it is possible to change the root username to something else (e.g. 'realroot') and then create a new user 'root' with all the same privileges (except those on the hidden databases).
I'm trying to install phpMyAdmin on my Ubuntu 10.10 server. I type the following command (I don't use "sudo" because I'm logged in as root, I know its not safe):
Quote: apt-get install phpmyadmin and go through the installation. I allow the installation to configure the database, and I chose the correct server (Apache2), when it asks for passwords, I use the same password that I use for the rest of the server (i.e. it is the account password for root, sudo, and my account). Once the installation is complete, I try and access it from a computer on the same network. I type "http://***.***.*.*/phpmyadmin" and I get the message saying the directory isn't there. I go into Webmin to confirm that the directory isn't there, and it isn't.
My questions are (1) Why isn't the phpmyadmin directory in my Apache Server root? (2) Is it installed with apt-get, if so, where? (3) How do I know what server I selected for it to install to? (4) What do I need to do to get it to install correctly?
I have two VMs, one as a web server and one as a database server. Both are RHEL5.2 Web server httpd-2.2.3-22.el5_3.1 php-5.1.6-23.2.el5_3 Database server mysql-5.0.22-2.1
On the web server, I can connect to the database just fine with a user I created with all privileges on *.*
Both phpMyAdmin and Drupal, though, tell me they cannot connect to the database. phpMyAdmin says :#2003 - The server is not responding..Drupal says:Failed to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on '172.16.1.1' (13).However, I can also connect to the database with a simple little PHP test script.What do I need to do to get these apps to see the database that is up, running, available, reachable, in existence, etc. etc???
I am at work right now and noticed my blog is down because of a database connection error. phpmyadmin wont load either it says theres an error, and webmin wont load either. So what would cause a mysql to go down? a hack or update? i am running ten.o four ubuntu server.
View 3 Replies View RelatedWhat commands can be used to install software such as "phpMyAdmin" to Fedora? As I am setting up Apache in Fedora. How to install "phpMyAdmin" and setup phpMyAdmin, so that I can use internet explorer to manage the phpMyAdmin to configure the MySQL database remotely.
View 2 Replies View Relatedi am having problems with privileges i have created a new user with my name, but i cant get root privileges on it. i need the same privileges as the root profile.
View 9 Replies View RelatedI run ProFTPd with TLS authentication on my Debian Lenny server. My problem is that despite of the fact that my users connect chrooted, one of my friends had root privileges after logging in form a Macintosh and could browse the root directory, too.
View 1 Replies View RelatedNeed help maintaining permissions across multiple directories. Have Ubuntu 8.04 Hardy Heron. O/S installed, updated and running with no problems.Why is it that my administrator user id doesn't seem to have root permissions to create directories? I am trying to setup hosting 3 separate websites and therefore create 3 separate directories to manage all associated files for the 3 websites. Also, I am attempting to read through the tutorials located at:URL...
View 4 Replies View RelatedWe formatted a USB stick to EXT3 for use on a linux formatted device.Now, when we try and transfer files from this ubuntu laptop onto the USB stick, it says permission denied.
View 4 Replies View RelatedAll of as now the add-to-panel item that via it you can shutdown the PC without the need of typing any password to gain root privileges.
How is this possible? I know that fro default the login screen is run by root but how do this app sends the signal to the login-screen to shutdown?
I mean, this app is run without root privileges by me, the simple user, and when clicked the PC shutdowns via a signal from this app to the login screen....
How can I call this signal to an app of mine?
We have Ubuntu 8.0.4. We'd like to give this one user the ability to reboot the server but no other root privileges. I'm assuming this can be done using sudo. What file and what change do I need to make to it?
View 3 Replies View RelatedI just installed this floppy drive in my computer and I can view files on floppy disks but I can not add files to a disk, formating will not work. All the privileges and ownership are set as root and I can not change them. (But I physically own it) Here is what the privileges are set for:
View 1 Replies View Relatedchanging the su password so i can install things. I was told to replace it with sudo because it is locked. I did this but i didnt work, it said my permissions are denied. How do i get root privileges in the terminal?
View 1 Replies View Relatedi know the subject is hard to understand but i did my best with it. the problem: i have 2 HDs on my Ubuntu OS, the first is 1TB and the other is 500GB, i want to do a backup with rsync from my 1TB HDs (in with the Ubuntu is on it) to the 500GB.
on the 500GB i have a partition called Backup. what i did: i have created a user crontab that dose two things: 1. mount the Backup partition from the 500GB to a folder called /~/Backup on my home directory which is on the 1TB HD.
2. i wrote the proper rsync command for the backup to go.
[Code]...
Tell me how I can I login as root?I want to get root privileges in www directory because I have a web server and I want to put there my site and I can not do that
View 6 Replies View RelatedI am basically on a Fedora 8 but I have some of my files on telnet machine, to which I can log on. There I don't have root privileges though. How can I transfer files from that machine to my machine, using ftp or some other mechanism?
View 2 Replies View RelatedAlso, how can I change between the two?
View 4 Replies View Relatedi have centos5.3 i want to create user with non admin privileges he is unable to see contents of server only he will able to login nothing else
View 12 Replies View RelatedIs there a way to grant 'root' privileges to my user account? My account name ... I'll call it 'masterskop' as it is my forum name here, but not on my computer.Would it look like this in the sudoers' file?My purpose is to get access to all the folders and files in the 'File System'. The root and lost+found folders have 'Xs' on them...No access! And for example, under properties of the 'var' folder it states that 'you are not the owner, so you cannot change these permissions.' How can I get access to all of it everytime I login as the main user of my computer? I do not have anyone else using this computer.I did edit this file and used my real user name ... logged out and logged back in and still I do not have access/edit these folders and files.
View 4 Replies View RelatedI have the script below that I want to run when my sister logs into her account. But the problem is that `ifconfig up` or `ifconfig down` requires root privileges. How do I initiate the program when she logs in and have root the the runner of the program.
Code:
#!/bin/bash
while true
do
elevenpm=`date +%s --date "2300"`
[code]....