Fedora Installation :: Mysql Fc14 Can't Create New User?

Nov 10, 2010

I 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)

View 3 Replies


ADVERTISEMENT

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

Programming :: Create A User For Php/MySQL Under Ms Win Environment?

Jun 30, 2010

create a user for php/MySQL under ms win environment?

View 1 Replies View Related

OpenSUSE Network :: MySQL Create User/permissions?

Jan 13, 2010

MySQL 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 Related

Server :: Create A Virtual User System With Mysql?

May 27, 2011

I'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?

View 8 Replies View Related

CentOS 5 :: Phpmyadmin Unable To Create A New User In Mysql Database

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

Fedora Installation :: Create 6GB /user Partition And It Says Not Enough Disk Space?

Oct 4, 2010

I have a 80GB HDD on which I have installed Ubuntu10.04. I have about 45GB space remaining. I am trying to install Fedora13. I create : 2GB / partition - 2.4GB swap partition. I want to create 6GB /usr partition and it says not enough disk space? Why is it giving that message?

View 1 Replies View Related

Debian Installation :: How To Create A New User Called Mesk As FTP User

Sep 3, 2014

I have just installed vsftpd on my debain server..I want to know how can I create a new user called mesk as FTP user and set a home page to some folder on my server? I tried this:

Code: Select allhtpasswd -c /etc/vsftpd/passwd mesk but got: cannot create file /etc/vsftpd/passwd.

View 3 Replies View Related

Fedora Installation :: FC14 Installation Crashed To Grub Prompt

Dec 20, 2010

I decided to upgrade my FC installation to the latest version - FC itself offered the upgrade when I turned the machine on, so it appeared that it was nicely packaged to make the upgrade easy.After a long download of packages, the machine rebooted and then started taking me through configuration options (timezone, disks to use for the installation etc) but then it crashed trying to write to disk and now leaves me at a grub prompt whenever I boot.Is there any way to "get at" the installation files and get back into trying to install or do I now need to download an ISO and burn a DVD and start all over again?

View 1 Replies View Related

OpenSUSE :: Create A Database With The Mysql That Came With The Suse Installation?

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

Fedora Installation :: Can't Install FC14 / Sort It?

May 13, 2011

I'm trying to install FC14 on my box... without any success so far

The problem: when it comes to write the partitioning scheme to the disk, the system freezes. This occurs with the following CD images:
- Fedora 14 LXDE live image. Installation using "Install to Disk" script.
- Fedora 14, regular i386 image
- Fedora 15 (beta) LXDE live image

I did further tests and found out that I could simply reproduce the problem by trying to write a partition on /dev/sdb using fdisk:
- after executing the fdisk 'w' command, the system hangs for about 10-15 seconds
- no kernel message can been seen during this time using dmesg
- after those 10-15s, the system freezes. I have no other option but power off the machine.

There is no Hardware problem with the disk itself. I can read/write partition on that disk without problem using another distro.

Does someone have a few ideas what to do?

View 5 Replies View Related

Fedora Installation :: Trying To Get Dial-up Working On FC14

May 14, 2011

I'm trying to get dial up working using wvdial, kppp or system-config-network. Whatever I try, it shows "no modem found." I'm using a US Robotics serial modem that's worked with other linux set-ups, so I know it's not the modem. What's the command to find a serial modem in the terminal? lspci doesn't show it.

And any info on getting any of these to work..especially system-config-network! Had it working with linux Mint's LXDE on an older Thinkpad, but something happened after an up date (kept saying that an IBM system was detected and refusing to load a module when it booted.) After update, didn't show that warning, perhaps loading the module.

Old Thinkpad hasn't loaded an operating system since! Won't even load gparted so I can get something else on it.....so I'm sticking with Fedora until I can figure it out. Got another old Thinkpad, don't want to repeat the same mistake. Guessing that it's a debian problem, as Mint's never broken anything before.

View 14 Replies View Related

Fedora Installation :: 13 Installation After Fc14 Is Installed Partitioning

Dec 27, 2010

I am trying to install 2 or 3 versions of linux on my hardisk of 500GB capacity. The configuration of my machine is Intel Dual Core, 4 GB Ram, 3.0 Processor Windows XP is not installed on this. I tried to use a tool called GParted but was unable to use as it was not able to bring up the XServer So I booted the machine with fedora14 installation CD and chose "Custom Layout" After reading about the partitions needed by Fedora I created 3 partitions in /dev/sda /dev/sda1 the boot of 500MB formated as ext4 /dev/sda2 the swap of 6096MB formatted as swap /dev/sda3 / size 150GB formatted as ext4

The installation went well and fc14 runs well on this. However when I went to install the other linux version ....the installer was not able to recognize the unallocated space of nearly 350 GB on the hard disk.....So I am not able to create new partitions and then install the new linux on the newer partition. As a result I am unable to make use of the remaining space on the HDisk. I think I should have created /dev/sda4 /dev/sda5 etc when I installed fc14 itself....

View 4 Replies View Related

Fedora Installation :: Partitioning Scheme FC14 X86_64?

Dec 20, 2010

I am going to set up a home server (command line only) with 2 x 1 GB HD and 4G memory. hat partitioning scheme would you recommend? Not more than 5 users Fedora Core only Will host a web page Will run DNS, DHCP, SAMBA, LAMP, NTP, Firewall, etc.. Just normal stuff.The server will host a large amount of video/audio/picture files

View 5 Replies View Related

Fedora Installation :: FC14 Won't Fully Install / Make It Possible?

Dec 24, 2010

New 320 Gig HD. Installed FC14 from DVD and it worked, except there are no icons at all to get started as there were in FC 13. Cant find "Places", "Applications" that were at the top of the screen. Now it's blank except for the splash design. Tried to re-install, but it won't do that. Just goes to the HD and the same blank splash screen. Thanks for the help. Please be easy with explanations as I'm new at this.

View 14 Replies View Related

Fedora Installation :: Yum Update Error Fc14 - Fc15

Apr 25, 2011

I have work through fedora project guides and got these messages beneath.

[code]...

View 4 Replies View Related

Fedora Installation :: Upgrade The Kernel To FC14 And That Has Toasted?

May 9, 2011

I had a FC13 box which I ran a yum update which obviously does updates to the packages installed. My issue is that its tried to upgrade the kernel to FC14 and that has toasted by install. now when the box boots up I get this on the screen.

[ 1.741672] Kernel Panic - not syncin: VFS: unable to mount foot fs on unknown -block(0,0)
[ 1.741715] Pid: 1, comm: swapper Not tainted 2.6.35.12-90.fc.x86_64 #1
[ 1.741754] Call Trace:
[ 1.741789] [<ffffffff81468d6f> panic+0x8b/0x10d

there are a few more lines like te last one. I've tried a rescue disk but no good. is my box toasted for good? I've used a live cd and can still the data on the box, is there any way to resue this situation? or is it run live cd backup the data and do fresh install?

View 4 Replies View Related

Fedora Installation :: Yum Update For FC15 After Upgrade From FC14

May 27, 2011

After doing an upgrade from FC14 to FC15, I then updated the packages by doing:
yum update yum
yum clean all
yum --releasever=15 --disableplugin=presto distro-sync
I then get the following voluminous list of issues (148 pre-existing rpmdb problems). I've done an rpm --rebuilddb but no help.

Running rpm_check_debug
ERROR with rpm_check_debug vs depsolve:
libclutter-gtk-0.10.so.0()(64bit) is needed by gthumb-2.12.3-2.fc15.x86_64
Please report this error in [URL]

Found 148 pre-existing rpmdb problem(s), 'yum check' output follows:
ImageMagick-c++-6.6.4.1-15.fc14.x86_64 has missing requires of ImageMagick = ('0', '6.6.4.1', '15.fc14')
akonadi-1.5.3-1.fc14.x86_64 has missing requires of libboost_program_options-mt.so.1.44.0()(64bit)
alchemist-1.0.37-8.fc12.x86_64 has missing requires of python(abi) = ('0', '2.6', None) .....
Your transaction was saved, rerun it with: yum load-transaction /tmp/yum_save_tx-2011-05-27-10-30qO4br9.yumtx

Well, it appears that downloading and installing libclutter-gtk-0.10.so.0 seemed to fix all the subsequent yum error messages, and I was able to install all the packages.

View 4 Replies View Related

Fedora Installation :: Database Conversion From Mysql 4.1.22 To Mysql 5 For A Client?

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

Fedora :: Creating User For Mysql?

May 21, 2010

I am having fedora 12 with php and mysql rpms installed on my computer.. but I am unable to log in...nether create an user?

View 3 Replies View Related

Fedora Installation :: FC14 Very Slow Opening Website Pages?

Dec 27, 2010

I just installed FC14 on 2 different PCs. It takes over 40 seconds for either of them to open some webpages, ie amazons home page. It is not my internet connection. I can open the same webpage on both my Windows PCs in less than 5 seconds. I was using FC9 up until 1 month ago, and I believe it took about 15 seconds to open amazon, but I never actually timed it. I spend many hours a day on the internet and have used FC for many years. I have been very happy with it. Until now. My PCs are 1.8GHZ single processor and 2.4GHZ dual processor. Do I have to revert back to FC9 to fix this, or use a different distro?

View 4 Replies View Related

Fedora Installation :: Fc14 Preupgrade To Fc15 Hang On First Boot

May 27, 2011

i have just upgraded from f14 to f15 using preupgrade. i am now still waiting for the first boot to finish. the screen is stuck for more than an hour and the last line written was:

Started LSB: Start up the OpenSSH server daemon. and there is a blinking cursor.

View 3 Replies View Related

Fedora Installation :: Akmodsbuild Error After Upgrade FC14 - FC15

Jun 4, 2011

Dell Studio 1555 (Wireless WLAN 1397 Half MiniCard (4312bg)) I'd tried

Code:
# akmods --force
5.100.82.38-1-for-2.6.38.6-27.fc15.i686.PAE.failed.log is attached. How to build akmods?

View 3 Replies View Related

Fedora Installation :: FC14 Upgrade Breaks X, Nouveau/nvidia?

Jun 17, 2011

My system with kernel-2.6.35.10-74.fc14.x86_64, NVIDIA 3800 + Samsung 2233 and 3Dvision kit works fine, but upon upgrading to kernel-2.6.35.13-92.fc14.x86_64 the system won't go past the blue->white bar along the screen. The modprobe.d directory has the file blacklisting nouveau and there is the grub entry rdblacklist=nouveau, but do I need to re-run the nvidia installer. If so I think I need to reset the init level to stop X11 trying to load. and will I need to keep doing this everytime I upgrade the kernel if I have nvidia drivers installed?

Leigh123linux desired code output is below

***
abrt-addon-kerneloops-1.1.18-1.fc14.x86_64
kernel-2.6.35.10-74.fc14.x86_64
kernel-2.6.35.13-91.fc14.x86_64

[Code]....

View 2 Replies View Related

Fedora Installation :: Fc14 Hangs After Kernel Update / Solution For This?

Aug 8, 2011

I am unable to boot with kernel 2.6.35.13-92.fc14.x86_64 which was installed while applying software updates. It hangs with the last message issued "Registering binary handler for Windows Applications". Searching led to it being related to a problem with the nvidia drivers. I followed the directions in several posts - delete /etc/X11/xorg.conf, reboot, run nvidia-xconfig, reboot and all is fine, but not in my case. The first reboot works but the screen is wrong. There is a 1 inch wide black border around the presentation window. If I then do the nvidia-xconfig and reboot, i am back to where I was before - boot hangs after issuing "Registering...". If I boot to the last good kernel, everything works fine. This happened to me once before and I was able to fix it by rebuilding the nvidia kernel (I think that was what I had to do), but I can't find out how to do that. I have akmod and kmod installed which are supposed to take care of this problem. I booted to kernel 13-92 recovery mode, deleted the xorg.conf file and ran nvidia-xconfig from there. Still fails. I don't know what to list here, but I will do my best to supply whatever is necessary.

View 1 Replies View Related

Fedora Installation :: FC14 Installer Not Driving Video Card?

Aug 14, 2011

I am about to upgrade my wife's PC from FC12 to FC14. The DVD boots OK and the disk check passes OK. The installer get to the point that it says 'Running Anaconda' (or words to that effect), then the screen is cleared, a brief flash of garbled graphics appears at the top of the screen, then all goes blank.

If I select the option to install using a basic video driver, I get the expected installation screens appearing centred but scaled down within the display, as though the image was a 640x480 window in, say, a 1024x768 display (those figures are guesses, but give the right idea).

I can install this way, but first want to check that this will not leave me with a scaled-down display when I boot to FC14. In other words, will FC14 recognise my (elderly) video card correctly, even though the installer does not?

The machine is running fine under FC12 and I did not strike this problem when I upgraded it to that version.

I have tried the upgrade using two different DVD images, in case one had a fault that the disk check did not pick up.

View 3 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

I'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]...

View 13 Replies View Related

Fedora Servers :: MYSQL MAX Connection Per User

Sep 28, 2009

I am running a mysql 5.0.41 community edition server.i have a user x and i need to set max connection limit for the user... Can any one give the correct syntax to update the current user to include max connection for the user x.

View 1 Replies View Related

Fedora Installation :: Microphone Doesn't Work With FC14 On Dell Laptop

Nov 18, 2010

How to make the mics work on a Dell XPX M1330 laptop. This seems to be a common problem with built in mics on laptops. I've tried all the obvious things with alsamixer and pulseaudio.

View 1 Replies View Related

Red Hat / Fedora :: Login - Error "no Profile For The User Can Be Found And It Couldnt Create Per-user Gnome Configuration Directory"

Aug 8, 2010

I have a network set up that has been working for around a year with no problems but has now developed a login problem. The system was set up with a main server with all users on it and another PC located elsewhere that people could log onto using there personal login and password that then gained access to the account on the main server. This remote PC has now got the problem. When you try to log onto an account it comes up with the message "your session has lasted less than 10 seconds. If you have not logged out yourself this could mean there is a installation problem or that you are out of disk space."

Error message says that no profile for the user can be found and it couldnt create per-user gnome configuration directory. I can log on as root onto the remote PC as it is obviously a local account but all the account on the main server are not accessible. From the root account I can see that the connection to the server is OK and I can actually log into the accounts on the server using the failsafe session so the physical network is OK.

I never built or designed this set up and to be honest I normally work with windows so its all a bit strange to me. Both PC's run Centos 5. I have checked the messages log and there doesnt seem to be any indication of a problem. Just that it stopped connecting from the remote PC. The accounts are all active on the main server itself and have no problems being accessed.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved